Im new to Zapier, and im going from Cognito Forms to Google Sheets, entering line items for form entries into google sheets, but I need to create an equation, and Im struggling to find a way of referencing a cell in the line its writing to.. for example…. =if(P(ROW())="Yes",(concatenate("T",ROW()-1," - ",)),"").
Its the P(ROW(), in having issues with, cause it needs to be something like P32 if Im on row 32.
The rest of the line is being created from Cognito fields so thats fine.
+14Hi
Good question.
One option is to use Airtable instead of GSheets.
Airtable has Formula fields: https://support.airtable.com/docs/formula-field-reference
Airtable Formula fields work within the row and don’t have the row reference issue you’ve encountered with GSheets.
OR
You can try this GSheets Formula:
=if(indirect("P"&ROW())="Yes",concatenate("T",ROW()-1," - "),"")
Unfortunately that didnt work. Its bizaare as the "T",ROW()-1 works, but not the "P"&(ROW()), it doesnt interprete the row in that part of the forumula
+14Try this formula:
=if(indirect("P"&ROW())="Yes",concatenate("T",ROW()-1," - "),"")
+11Hey
Just checking in to see whether you were able to get it working using the formula Troy shared? Let us know if you need any further help on this!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
