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

Options

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.

Tags:

Best Answer

  • BillyBossier
    BillyBossier ✭✭✭
    Answer ✓
    Options

    =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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!