What is wrong with my IF formula

=IF([Transportation Type]@row ="Rental Car", "CWT Code Required”, IF([Transportation Type]@row=”Air”, "CWT Code Required" ,IF([Transportation Type]@row=”Train”, "CWT Code Required")))

Best Answers

Answers

  • Nick Burrus
    Nick Burrus ✭✭✭✭✭✭

    YOu are missing a closing statement.


    =IF([Transportation Type]@row ="Rental Car", "CWT Code Required”, IF([Transportation Type]@row=”Air”, "CWT Code Required", IF([Transportation Type]@row=”Train”, "CWT Code Required", "Closing")))

    Dr. St Nicholas Burrus DHA, PMP

    I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.

  • Still gives me an error....

  • I re-typed the quotes and it worked. Thanks all!

  • Genevieve P.
    Genevieve P. Employee Admin

    Glad you could get it working! 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!