Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula Help (does not contain)

Laura
Laura ✭✭✭✭✭✭

Columns

"Risk"

"Start Date"

"Part Status"

 

I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress"

 

I have the formula below for if start date is today or >

 =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1))

 

How can I combine AND if "Part Status" is NOT "shipped" or "in progress" into this formula?

 

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Try this, I got it to work for me. <> means does not equal. 

    =IF(AND(TODAY() > [Start Date]4, OR([Part Status]4 <> "shipped", [Part Status]4 <> "shipped")), 1, 0)

  • Laura
    Laura ✭✭✭✭✭✭
    edited 09/14/17

    This isn't working.

    The start date is 8/28/17 and the part status is "in progress" meaning a red flag should not be triggered.

    =IF(AND(TODAY() > [Start Date]47, OR([Part Status]47 <> "shipped", [Part Status]47 <> "in progress")), 1, 0)

     

    I need the flag checked

    IF START DATE is today or less than today

    AND

    Part Status is NOT shipped or in progress

     

    What am I doing wrong?

     

    IF start date is today or in the past = Flag

     

    IF start date is today or in the past but part status is shipped or in progress = No Flag

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Hi Laura, I do not have time right now to troubleshoot this. I am hoping someone from the community can pitch in! If I get a break in time I will attempt to figure it out for you. But probably not till next week. 

  • Laura
    Laura ✭✭✭✭✭✭

    Thats okay! Thanks for your help

This discussion has been closed.