NOT "Complete" or "Not Applicable"

Reggie Andaya ✭✭✭✭✭

10/28/22 in Formulas and Functions

Hi,

How would this be written to say NOT COMPLETE or Not Applicable?

=IF(AND([End Date]8 < TODAY(), NOT(Status8 = "Complete","Not Applicable"), 1, 0)

0 · Share on FacebookShare on Twitter

Answers

• 

  Michael Culley ✭✭✭✭✭

  10/28/22

  =IF(AND([End Date]8 < TODAY(), [status8]@row <> "Complete", [status8]@row <>"Not Applicable"), 1, 0)

  1 · Share on FacebookShare on Twitter
• 

  Reggie Andaya ✭✭✭✭✭

  10/28/22

  @Michael Culley Appreciate your help. Have a good weekend

  0 · Share on FacebookShare on Twitter

Sign in

Try Smartsheet

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list