
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 13, 2021 01:06 PM
I’m trying to create a formula whereby :
IF [date 1] is after [date 2] OR [date 3] is after [date 4] to tell me “Needs Review”, otherwise “Updated”.
How do i do this? i’m not sure how to compare the date fields.
Thanks!
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 13, 2021 01:08 PM
IF(
OR(
{Date 1} > {Date 2},
{Date 3} > {Date 4}
),
"Needs Review",
"Updated"
)
