If Then Formula for 2 Columns

cwwoodsum

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?

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"

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"