can't get this formula to work correctly -- adding a check box if contains
Hi all,
I have a box with a dropdown menu with 3 options but you can put multiple items into the box.
The dropdowns are
GPA
PACE
Max Time Frame
I have 3 columns check "gpa" check "pace" check "Time Frame
This is a sample formula there is one for GPA and PACE
=IF(CONTAINS([SAP Issue]@row, "Time Frame"), 0, 1)
I want the formulas to check the box on the row if it contains "Time Frame" and leave unchecked if the row doesn't have "time frame".
It looks like it works it but the answers are just wrong. These are column formulas.
I just can't figure out what is wrong. any ideas.
thank you for your time.
Best Answer
-
=IF(FIND("PACE", [SAP Issue]@row) > 0, 1, 0)
I fixed my own problem. The command above works. Sorry I'm leaving this in just in case someone else has a similar problem. My apologies for taking your time.
Answers
-
so I investigated further.
If I have one answer it works if I have multiple answers in the cell it doesn't work. But that was why I used the contains command instead of something else.
-
=IF(FIND("PACE", [SAP Issue]@row) > 0, 1, 0)
I fixed my own problem. The command above works. Sorry I'm leaving this in just in case someone else has a similar problem. My apologies for taking your time.
-
Hey, looking at your formula, you have the 1 and 0 backwards and also your criteria and range are backwards for the contains. Try this
=IF(CONTAINS("Time Frame", [SAP Issue]@row), 1, 0)
-
Hi Eric thanks for your response. I had tried it both ways 1,0 and 0,1 and for some reason it didn't make a difference. The formula just didn't like the multiple possible answers and maybe the drop box combo. When I switched to the find command instead it worked. I honestly have no idea why. Though if anyone has any ideas I would love to understand but the formula below works.
=IF(FIND("PACE", [SAP Issue]@row) > 0, 1, 0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!