Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Automation, formula, or something else?

Topic Labels: Formulas
95 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, going off of my previous topic about gardening in “How can I use a formula for the below data?” I am wondering if there is a way to mark a row to show that I missed the target date for the plantings. Say like my target date is 11/20/22 but I didn’t get around to it till the 23rd. Is there a way to make it automatically color or trigger that row saying that I went over that date? Thanks.

1 Reply 1

Formula:

IF(
{Date Completed} > {Target Date},
"went over",
"okay"
)

^^ Then set your View’s record coloring to use the condition Formula contains went over