Flag is true when status is not complete and date modified is 5 days old

Michael D.

Hello, in an effort to automate update request emails for items that have been stuck at a specific status for a period time, I am trying mark a flag as true when the row status is not complete, and the date modified is more than 5 days old.

I think I need an IF And formula and having difficulty incorporating the and statement. Does anyone have any recommendations?

Mark Cronk

=IF(AND(NOT(staus@row="Complete"), Modified@row<today(-5)), 1, 0)

Mark

Mark Cronk

=IF(AND(NOT(staus@row="Complete"), Modified@row<today(-5)), 1, 0)

Mark

Michael D.

Thanks Mark, worked perfectly! Now I just set up conditions in my update request for when this field is changed.

Thanks for the help!

Mark Cronk

Hi Michael, Happy to help. Thank you for contributing to the Community.

Mark