Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am trying to set up a formula to add to a column in zoho sheets when a new row is added to the zoho sheet. The formula I am using works when I manually enter into zoho sheets but not when I am setting up the zap in zapier. Keeps telling me that there is a syntax error. Here is the formula: 

=IF(5-(TODAY()-E[[row_number]])>0;5-(TODAY()-E[[row_number]])&" day(s)";"Past Due")

I have adjusted the row number to show the row index option under transform > formulas. 

Does anyone know what I am doing wrong here? 

 

Locale settings in zoho sheets: 

Decimal separator Dot (.) 

Grouping separator Comma (,) 

Locale settings in zoho sheets: 

Decimal separator Dot (.) 

Grouping separator Comma (,) 

Hi ​@Kaitlyn T 

For us to have more context, post screenshots showing how your Zap step is configured in the CONFIGURE tab while in EDIT mode with the field mappings visible so we can see the field types.

 

TIP: Click field labels to see tooltips with more info.

Hi ​@Troy Tessalone Here is the zap, let me know if you need more information. 

 

​@Kaitlyn T 

If you are trying to use a Formula in a Formatter step, you would need to map variables from previous Zap steps.

Help link for how to map variables between Zap steps: https://help.zapier.com/hc/en-us/articles/8496343026701-Send-data-between-steps-by-mapping-fields

​@Kaitlyn T 

Also, a Formatter step can not be the last step in a Zap.

 

How are you trying to configure the Zap action step to set the formula in Zoho Sheets?

Okay, I will look into mapping the variables. Yes, the last step will be to update a row, but I have not been able to get to that step since the formula is not working. 

Thank you! 

Hey ​@Kaitlyn T,

Also Today() as a function will not be directly supported in this action if you see the supported functions here- https://help.zapier.com/hc/en-us/articles/8496181204877-Available-spreadsheet-style-formulas. For exponent you have to use EXP(number, power). Hope it helps!

Hi ​@Sparsh from Automation Jinn We are trying to use “today’s date” when using TODAY() not an exponent. Does that change things? 

Hi ​@Troy Tessalone Our process that we are trying to get to work is when a new row is updated in zoho sheets column A-E will trigger the formula to be added into column F, pulling the date from column E to start a countdown timer. When we add the formula into zoho sheets manually there are no issues. Only when the formula is added in zapier. 

 

 

Hey ​@Kaitlyn T,

Then instead of E[row_number] you can just dynamically map that row. I don’t think TODAY() is directly supported. Formulas function in Zapier will be different than the one in the sheets. You will have to change the logic to approach this Zap.

For today’s date try using Formatter by Zapier → Date/Time → Format and then giving {{zap_meta_human_now}} to get the current date. Hope it helps!

​@Kaitlyn T 

For us to have more context, post screenshots showing the how you are trying to configure the Zoho Sheets Zap action step that way we can see the field types.

Click the field label for the column to see if there is a tooltip with more info. (post screenshot)

If supported, if you are trying to insert a formula into a Zoho Sheets row column, then that column would need to support formulas.

Seems like all you would have to do is replace “E#” with the # of the row that triggered the Zap step.

 

 

Terms & ConditionsAccessibility statement