Excel Translation

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"

Find more posts tagged with

Accepted answers

Try this:

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

I hope that helps.

Cheers,

Ramzi

All comments

Try this:

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

I hope that helps.

Cheers,

Ramzi

That did the trick, thank you!

Glad to help.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.