Excel Translation

Options

How do I translate this to Smartsheet?

=IFS(C3="black",1,C3="blue",2,C3="red",3,C3="green",4)

I realize there is no IFS function an that I need to nest the information, but I can not get the formula worked out.

=IF[Color]1=Black,"1"


Best Answer

Answers

  • Steven Butler
    Options

    That did the trick, thank you!

  • Ramzi K
    Ramzi K ✭✭✭✭✭
    Options

    @Steven Butler

    Glad to help.

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!