IF AND Formula Workaround

terrencekm
edited 12/09/19 in Formulas and Functions

Hi All

I am trying to get a formula working whereby if

  1. END DATE is in the next 3 days
  2. END DATE is not blank
  3. Status is either (In Progress, Not Started)
  4. At Risk flag will be indicated (, 1)

Many thanks

screenshot.jpg

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!