If Then Formula for 2 Columns

Hello everyone,

I'm still a "new" Smartsheet user even though I've been using it for over a year. I want to set up the following formula: if column A equals 1 then column B equals 2. I want to apply the formula to both columns. For more specific details, the terms I'm using are:

IF VPM Categorization equals Cost, THEN Money Saved equals Yes

How do I set this formula up and apply it to the VPM Categorization column?

Find more posts tagged with

Formulas

columns

Accepted answers

Colleen Patterson

You would actually put the formula in the Money Saved Column.

=IF([VPM Categorization]@row = "Cost", 1, 0)

This would check a box in that column, if formatted that way. If you would rather it show as yes / no, change the 1 to "Yes" and the 0 to "No"

All comments

Colleen Patterson

You would actually put the formula in the Money Saved Column.

=IF([VPM Categorization]@row = "Cost", 1, 0)

This would check a box in that column, if formatted that way. If you would rather it show as yes / no, change the 1 to "Yes" and the 0 to "No"

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.