- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2025 02:43 PM
Very new to Airtable and having some fun with formulas.
I have project records with a simple status field (Planned, In Progress, Completed) and some basic date fields.
I created a formula that checks if the project is "On time" or "Overdue" based on the completed (planned or actually completed) date field vs today.
I don't need this formula to calculate on Completed projects so i'm looking for a formula that sets the field to blank if status is Completed, but calculates if Planned or In Progress.
Current checking formula:
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2025 03:11 PM
Hey @AdamZame!
You’ll want to have a nested IF formula. Please give this a shot and let me know if it works for you:
IF(
{Status} = "Completed",
BLANK(),
IF(
{Completed Date} < NOW(),
"Overdue",
IF(
IS_SAME({Completed Date}, TODAY(), 'day'),
"At Risk",
"On Time"
)
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2025 03:11 PM
Hey @AdamZame!
You’ll want to have a nested IF formula. Please give this a shot and let me know if it works for you:
IF(
{Status} = "Completed",
BLANK(),
IF(
{Completed Date} < NOW(),
"Overdue",
IF(
IS_SAME({Completed Date}, TODAY(), 'day'),
"At Risk",
"On Time"
)
)
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2025 03:27 PM
Thanks Mike,
That worked great.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2025 04:28 PM
Always happy to help @AdamZame!
If you have any other Airtable related question, feel free to schedule a call using this link!
Mike, Consultant @ Automatic Nation
