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?
Best Answer

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"
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Answers

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"
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Help Article Resources
Categories
Check out the Formula Handbook template!