If function based on multiple columns


I have done formula on column 3 and 4

if column 3 returns yes and column 4 is blank, the status will return from column 3

but if column 4 has yes in it, the status will return from column 4 ignoring what is column 3

I want to add the column 5 in the same formula with the same principle

if column 5 has yes, status will be yes, otherwise it will look at the column on the left

if column 4 is blank it will look at column 3

@Paul Newcome @Genevieve P. i have tagged you guys hoping you can help directly please

would really appreciate your advise


Best Answer

  • Kelly P.
    Kelly P. ✭✭✭✭✭✭
    Answer ✓

    @Maz Uddin

    It's easiest and cleanest to write the formula backwards (in this case, from the rightmost to the leftmost). Try this:

    =IF([Column5]@row = "Yes", "C Approved", IF([Column4]@row = "Yes", "B Approved", IF([Column3]@row = "Yes", "A Approved")))

    Hope this helps!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!