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!