We are importing USD ($) and GBP (£) invoice data from Scoro to a Google Sheet. If the invoice values is $54,000 then Scoro exports it as 54,000. If it’s £54,000 it exports it as 54,000. What I want to do is to divide the value by 1.4 (our GBP to USD exchange rate), *IF* it is a USD value. We have a column which details ‘USD’ or ‘GBP’. Any thoughts?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 4
+6
- Beginner
- 135 replies
-
18 February 2022
1.Use Google Sheet New Row as the Trigger
2.Now Create two paths one each for USD and GBP where you can create Condition to check that particular column of Google Sheet
3.Add a Action Step of Formatter in the path where you want to divide the number by 1.4 selecting Action Event as Numbers and Perform Math Operation to Divide.
Userlevel 7
+14
- Certified Zapier Expert
- 23933 replies
-
18 February 2022
Hi
Some other options:
- Add a formula field with this IF logic in your GSheet: https://support.google.com/docs/answer/3093275?hl=en
- Use 1 Code step to do this IF logic in your Zap: https://zapier.com/apps/code/help
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.