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.
Always happy to work through questions or concerns!
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.
Always happy to work through questions or concerns!
Help Article Resources
Categories
Check out the Formula Handbook template!