Its probs simple but i cant work it out lol
var subject = SpreadsheetApp.getActiveSheet( ).getRange("Custome text + cell C5").getValue();
how would i get that to read like that so it combines my custom text + cell c5?
Thanks
Its probs simple but i cant work it out lol
var subject = SpreadsheetApp.getActiveSheet( ).getRange("Custome text + cell C5").getValue();
how would i get that to read like that so it combines my custom text + cell c5?
Thanks
Solved it as followed
var A ='Custom text ';
var B = SpreadsheetApp.getActiveSheet( ).getRange ("C5").getValue();
var subject = A+B
Can't you use this?
PS Can you add code tags when posting code?![]()
Please Login or Register to view this content.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks