IF formula mix AND & OR functions, dates on modified and created columns

krazy@irl
krazy@irl ✭✭✭
edited 12/09/19 in Formulas and Functions

I'm looking to add a formula which will check the dates in modified and created columns and update the status column. If the modified date is today and is greater than the created date I want to populate the Status column with "updated", but if the modified date is equal to today and if the created date is also equal to today then the Status column should display text "New".

If neither of the fields match todays date then the Status should be blank.

I have something working for displaying "updated"

=IF(AND(DATEONLY(Modified822) = TODAY(), DATEONLY(Created822) < TODAY()), "Updated", "")

and also if modified and created both contain todays dates then display as "New"

=IF(AND(DATEONLY(Modified976) = TODAY(), DATEONLY(Created976) = TODAY()), "New", "")

But I'm not sure how to combine the two if someone could help

«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!