Multiple IF function pull from multiple cells
I am working on a spend tracker and i am having trouble pulling currency conversions from other cells in the row.
I need the 'committed amount in USD' to pull from the correct currency conversion cell depending on the currency selected.
current formula i have that works with pulling from just one cell is -
=IF(Currency@row = "KRW", [KRW to USD]@row)
how can i add to this to make it pull from other cells if the currency is different?
I have been trying this and it isnt working-
=IF(Currency@row = "KRW", [KRW to USD]@row), IF(Currency@row = "GBP" , [GBP to USD]@row)
can anyone help?!
Jasmine
Best Answer
-
You are on the right track. It is just a minor syntax issue. When nesting IF functions, you leave the first one open and start the second in the "else" portion of the first. Then you start the third in the "else" portion of the second, so on and so forth. Then you close them all at the end.
=IF(this is true, do this, IF(that is true, do that))
=IF(Currency@row = "KRW", [KRW to USD]@row, IF(Currency@row = "GBP" , [GBP to USD]@row))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You are on the right track. It is just a minor syntax issue. When nesting IF functions, you leave the first one open and start the second in the "else" portion of the first. Then you start the third in the "else" portion of the second, so on and so forth. Then you close them all at the end.
=IF(this is true, do this, IF(that is true, do that))
=IF(Currency@row = "KRW", [KRW to USD]@row, IF(Currency@row = "GBP" , [GBP to USD]@row))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
ah amazing, wow, so close haha. thank you so much -really big help.
One more question whilst I have you here. The sheet I am creating is a temporary PO system - I am allowing other users to enter details onto the sheet (via form) to then receive a unique PO number based on the information they add in.
Is there anyway to show results of a concatenated cell on a form (i.e. the PO number to appear on the form once required information has been entered on the form?)
-
Hi Jasmine,
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment to have your vote added
A possible workaround, could be to use a third-party service. Is that an option?
I hope that helps!
Have a fantastic weekend & Happy Holidays!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks Andre, i submitted the idea :-)
When you say third party - is there a tool i can somehow add in to smartsheets that could solve this/generate a form with PO number and links back to my smartsheet?
Or do you mean create the entire PO system with a third party?
-
@Jasmine Brown Please do not forget to mark an answer that best fits your original post so that others looking for a similar solution know that one can be found here. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Happy to help!
Yes, it would be an integration to Smartsheet. There are a few that probably could work for your use-case.
Is that an option?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!