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