Multiple IF statements
I think I have a simple formula containing multiple IF statements but it is coming back as unparseable.
=IF([End Date2]1 = 1, "Sunday", IF([End Date2]1 = 2, "Monday", IF([End Date2]1 = 3, "Tuesday", IF([End Date2]1 = 4, "Wednesday", IF([End Date2]1 = 5, "Thursday", IF ([End Date2]1 = 6, "Friday", IF([End Date2]1 = 7, "Saturday")))))))
What is wrong?
Best Answer
-
You have an extra space in your formula in the Friday IF statement: IF ([End Date2]@row = 6
Answers
-
Try:
=IF([End Date2]@row = 1, "Sunday", IF([End Date2]@row = 2, "Monday", IF([End Date2]@row = 3, "Tuesday", IF([End Date2]@row = 4, "Wednesday", IF([End Date2]@row = 5, "Thursday", IF([End Date2]@row = 6, "Friday", IF([End Date2]@row = 7, "Saturday")))))))
Also, the formula should not be in a Date type column. That would have also given you an Unparseable error.
-
Thanks for the quick response. Based on your suggestion, I updated the formula to the following:
=IF([End Date2]@row = 1, "Sunday", IF([End Date2]@row = 2, "Monday", IF([End Date2]@row = 3, "Tuesday", IF([End Date2]@row = 4, "Wednesday", IF([End Date2]@row = 5, "Thursday", IF ([End Date2]@row = 6, "Friday", IF([End Date2]@row = 7, "Saturday")))))))
The formula is in a column type "TEXT/NUMBER".
It is still coming back as unparseable.
-
You have an extra space in your formula in the Friday IF statement: IF ([End Date2]@row = 6
-
=IF([End Date2]@row = 1, "Sunday", IF([End Date2]@row = 2, "Monday", IF([End Date2]@row = 3, "Tuesday", IF([End Date2]@row = 4, "Wednesday", IF([End Date2]@row = 5, "Thursday", IF([End Date2]@row = 6, "Friday", IF([End Date2]@row = 7, "Saturday")))))))
a space between IF
-
I am struggling with a multiple if statement....I need to have 8 total. Below is just a start with two. They each work individually (in separate cells) but when I put them together I receive the UNPARSEABLE error. Anyone that can help me get this to work?
=IF(OR([Place in Funnel]2 = "Universe", [Place in Funnel]2 = "Above"), "0%") , (AND([Place in Funnel]2 = "In", [Sales Stage]2 = "Lead"), "10%")
-
Hi Heather
Try this
=IF(OR([Place in Funnel]@row = "Universe", [Place in Funnel]@row = "Above"), "0%", IF(AND([Place in Funnel]@row = "In", [Sales Stage]@row = "Lead"), "10%"))
As written, the cell will be blank if the last clause returns a false. If this isn't what you wanted, insert a
, "whatever is the desired result"
in between the last two parentheses
-
Im Having trouble making this If Statement work, it Should be when the status row changes Colour then the second status row will change to complete,incomplete, in progress based on the dot colour
=IF ([Status 1]@row = Green, "Complete", IF ([Status 1]@row = Blue ,"In Progress" , IF ([Status 1]@row = Red, "Not Complete", "Blank"
-
I hope you're well and safe!
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up 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.
-
Hy Andree,
Could you please help me in fixing this Multiple IF statement :
Explanation:- I am referring Building No. to their respective account manager, What I would like is for the Account manager's name should appear with respect to Building No. But I am continuously getting one error #Unparseable
=IF([Equipment Name]@row<> "",IF(OR(Building@row)=FB1,FB2,LNK,FAB,"Mike Shape",IF([Building@row)=CB1,CB2,GIS,ELY,"Mike Brain",IF(AND(Building@row)=PS1,PS2,BGY," Mike Kitye")))
-
Hi @Shubha
The formula is unable to calculate because of how the OR Functions are set up. You'll need to list out each option within the OR statement, like so:
OR(Building@row = "FB1", Building@row = "FB2", Building@row = "LNK", Building@row = "FAB"), "Mike Shape"
Notice also that any time you're referencing a text string, it should be in quotes (e.g. "LNK")
Try something more like this:
=IF([Equipment Name]@row <> "", IF(OR(Building@row = "FB1", Building@row = "FB2", Building@row = "LNK", Building@row = "FAB"), "Mike Shape", IF(OR([Building@row = "CB1", Building@row = "CB2", Building@row = "GIS", Building@row = "ELY"), "Mike Brain", IF(OR(Building@row = "PS1", Building@row = "PS2", Building@row = "BGY"), "Mike Kitye"))))
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for your help. That Worked for me :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!