Hi,
I’m trying to build something that shows me the total value of products in a basket that meet slightly fuzzy condition. I’m using utilities and Number to do this but it means I need to use 5 tasks to do something that feels like it could be done in one.
IF("{{119107523__output__Products[]Items}}"="Family Main WGA +Don","{{119107523__output__Products[]Values}}","")
Any thoughts on how I could do something a little more like an IF OR?
Best answer by XRay Tech
Hi
Inside Formatter select Numbers. Then select Spreadsheet Style Formula from the dropdown inside the “Transform” field. Then enter your formula inside the “Forumla” field below.
You can read more about Zapier supported formulas here: https://zapier.com/help/create/format/understand-spreadsheet-style-formula-functions
+14Hi
Code steps, although more technical, allow for all sorts of custom logic to be done in 1 step: https://zapier.com/apps/code/help
+4Hi
Inside Formatter select Numbers. Then select Spreadsheet Style Formula from the dropdown inside the “Transform” field. Then enter your formula inside the “Forumla” field below.
You can read more about Zapier supported formulas here: https://zapier.com/help/create/format/understand-spreadsheet-style-formula-functions
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
