Google Sheets formula within make.com

How To
1

I’m facing an issue with a formula I’ve set up in Google Sheets:
=IF(ISNUMBER(FIND(",", INDIRECT("J" & ROW()))), SPLIT(INDIRECT("J" & ROW()), ","), INDIRECT("J" & ROW()))
It works perfectly within Google Sheets, but when I use the ‘Update a Row’ action in Make.com, the formula gets overwritten. I tried passing the formula directly into the field, but it seems Make.com treats it as plain text rather than executing it as a formula. Is there a way to replicate or handle this formula directly within Make.com?

3

I don’t believe you can use a google sheets formula within the google sheets module. You need to use Make functions within MAKE.

You can use the raw J in the row and update it and have a formula in row K that looks at J and is blank if J is blank.

4

Did you select unformatted as yes?

5

No I didnt use the advanced settings meaning I used value render option: Formatted value and Date and time Render Option Formatted String. Default settings