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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!