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

Answers

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    edited 11/06/20

    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.

  • Joseph Boyd
    Joseph Boyd ✭✭
    edited 11/06/20

    =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.

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

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    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"

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Connor Uphondo

    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, [email protected])

    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:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Shubha
    Shubha ✭✭

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

  • Genevieve P.
    Genevieve P. Employee Admin

    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

  • Shubha
    Shubha ✭✭

    @Genevieve P.

    Thanks for your help. That Worked for me :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!