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"
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"
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!