Excel Translation

Steven Butler

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"

Ramzi K

@Steven Butler

Try this:

=IF(Color@row = "Black", 1, IF(Color@row = "Blue", 2, IF(Color@row = "Red", 3)))

I hope that helps.

Cheers,

Ramzi

Ramzi K

@Steven Butler

Try this:

=IF(Color@row = "Black", 1, IF(Color@row = "Blue", 2, IF(Color@row = "Red", 3)))

I hope that helps.

Cheers,

Ramzi

Steven Butler

That did the trick, thank you!

Ramzi K

@Steven Butler

Glad to help.