Support
Help Center
Airtable Universe
Airtable Templates
Airtable Guides
Developer Documentation
Sign up for Airtable
Airtable Community
Announcements
Discussions
Ask A Question
Show & Tell
Development & APIs
Groups
Airtable AI
Airtable Enterprise Network
Marketing
Product Operations
EDUser Group
Events
Resources
Getting Started
Job Board
Product Ideas
Search
Community
Knowledge base
Arlo_James_Jack
Users
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Help
Sign In
Browse
Airtable Community
Arlo_James_Jack - profile
Arlo_James_Jack
4 - Data Explorer
since
Oct 26, 2022
Nov 29, 2022
User Statistics
2
Posts
0
Solutions
1
Kudos given
0
Kudos received
User Activity
Posts
Replies
Make something say DONE when done, OVERDUE when overdue, Approaching within one week
Oct 26, 2022
So I have the following: IF( TODAY() > {Date Due}, “OVERDUE” ) I have a Column named ‘Days’ for days left to do my task, so I made the following, using the nested IF tutorial: IF( TODAY() > {Date Due}, “OVERDUE”, IF({Days} < 5, “Soon”) ) I’m tryi...
Re: Make something say DONE when done, OVERDUE when overdue, Approaching within one week
Oct 26, 2022
Solved! Thank you so much, Jeremy. Just needed MORE NESTS
Kudos given to
User
Count
Jeremy_Oglesby
1
View all
