can't get this formula to work correctly -- adding a check box if contains

BillyBossier

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.

BillyBossier

=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.

BillyBossier

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.

BillyBossier

=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.

Eric Law

https://community.smartsheet.com/discussion/comment/409191#Comment_409191

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)

BillyBossier

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)