Hi with a bot i tried to copy a cell with a spreadsheet formula to another cell. In the second cell it is now copying the formula. but I want the bot to copy the text value.
Can anyone help?
Hey,
Hope you’re keeping well.
In AppSheet, when you copy a cell that contains a formula, it will normally copy the formula itself rather than the evaluated value. To get only the text value, you’ll need to use an expression that reads the computed value, such as referencing the column directly in your bot step instead of duplicating the formula. For example, in a “Set the value of a column” action, set it to [_THISROW].[ColumnName] so it stores the current value rather than the formula. This ensures the automation writes the resolved text into the target cell.
Thanks and regards,
Taz
thanks, but i wanted to copy the formula only for certain cells because of a gpt function in google sheets.
I fixed it with app script