What am I doing wrong in this formula?

Options

Where I am hung up is if the scheduled date is BLANK I want it to return the text PENDING SCHEDULE


=IF([Completed Date]@row <> "", "Completed", IF([Scheduled Date]@row <> "", "Scheduled", IF([scheduled date]@row "", "Pending Schedule")

Best Answer

  • ker9
    ker9 ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Applecor2

    Looks like you are missing an equal sign after the last "@row" - bolded below

    =IF([Completed Date]@row <> "", "Completed", IF([Scheduled Date]@row <> "", "Scheduled", IF([scheduled date]@row = "", "Pending Schedule")

    That jumped out at me but it's possible something else is wrong - let us know if that fixes it.

    Hope this helps!

Answers

  • ker9
    ker9 ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @Applecor2

    Looks like you are missing an equal sign after the last "@row" - bolded below

    =IF([Completed Date]@row <> "", "Completed", IF([Scheduled Date]@row <> "", "Scheduled", IF([scheduled date]@row = "", "Pending Schedule")

    That jumped out at me but it's possible something else is wrong - let us know if that fixes it.

    Hope this helps!

  • Applecor2
    Options

    That did it thank you so much....So easy!! :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!