
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2020 12:03 PM
I need some help editing my original formula which is:
IF(IS_BEFORE({Actual Site Walk}, TODAY()), “ :white_check_mark: Done:white_check_mark:”,IF(IS_BEFORE({Forecasted Site Walk}, TODAY()), “ :alarm_clock: OVERDUE:alarm_clock:”,“ :running_man: In-progress:running_man:”))
I’d like to add/change the formula to show “DUE SOON” for dates in the Forecasted Site Walk field that are within the next 14 days, but keep the rest as well. How do I do that? Thanks!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2020 05:42 PM
I tested this, and am pretty sure it works for what you want:
IF(
IS_BEFORE({Actual Site Walk}, TODAY()), "✅Done✅",
IF(
IS_BEFORE({Forecasted Site Walk}, TODAY()), "⏰OVERDUE⏰",
IF(
AND(
DATETIME_DIFF(TODAY(), {Forecasted Site Walk}, "days") >= -14,
DATETIME_DIFF(TODAY(), {Forecasted Site Walk}, "days") < 0
),
"DUE SOON",
"🏃♂️In-progress🏃♂️"
)
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 23, 2020 05:42 PM
I tested this, and am pretty sure it works for what you want:
IF(
IS_BEFORE({Actual Site Walk}, TODAY()), "✅Done✅",
IF(
IS_BEFORE({Forecasted Site Walk}, TODAY()), "⏰OVERDUE⏰",
IF(
AND(
DATETIME_DIFF(TODAY(), {Forecasted Site Walk}, "days") >= -14,
DATETIME_DIFF(TODAY(), {Forecasted Site Walk}, "days") < 0
),
"DUE SOON",
"🏃♂️In-progress🏃♂️"
)
)
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 24, 2020 06:22 AM
That worked! Thank you!! :grinning_face_with_smiling_eyes:
