IF or IFS Help
Hey Everyone,
Need some help with an IF formula that is getting an #UNPARSEABLE error. Below is the code that I am using to get this error.
=IF([# of POS]@row="4 POS", 26,0) IF([# of POS]@row="5 POS",28,0) IF([# of POS]@row="6 POS",28,0)
Any advice on correct codding would be great appreciated.
Thank you
Answers
-
Try this:
IF(OR([# of POS]@row, "5 POS", [# of POS]@row, "6 POS"), 28, IF([# of POS]@row = "4 POS", 26,0))
-
Hey Sameer,
I received a #Invalid Data Type
-
Hi @Cparker
I hope you're well and safe!
To add to Sameer's excellent advice/answer.
Try something like this. (I think Sammer missed changing to = on the first two parts)
= IF(OR([# of POS]@row = "5 POS", [# of POS]@row = "6 POS"), 28, IF([# of POS]@row = "4 POS", 26, 0))
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
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.
-
Hey Andre,
That worked. Thank you
-
Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives