Reference to a specific cell in a google sheet

Hi, I’ve set up an action to add a standard text to an SMS-message.

I’d like to have a sheet with cell that I can have the text in, so it is easily editable for me at the office. Is it possible to reference to a single cell, if so how?

1 2 959
2 REPLIES 2

Steve
Platinum 4
Platinum 4

A “cell” must be a column in a row of a table. Sounds like you’ll need a separate table with one row and two columns: a key column and a message column. You can then reference that message column value from any expression using the LOOKUP() function.

See also:

Nice out of the box thinking! Thanks! I’ll give it a shot.

Top Labels in this Space