# Multiple IF statements

Options

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?

• ✭✭✭✭✭✭
edited 11/06/20
Options

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.

• Options

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.

• edited 11/06/20
Options

=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` `( for row = 6.

• Options

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%")

• ✭✭✭✭✭✭
Options

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

• Options

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"

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭
Options

Hy Andree,

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")))

• Employee
Options

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