This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi everyone,
quite new to Airtable and being very impressed so far, I’m currently underway managing more complex formulas. Still, what I’d like to accomplish for my task management table is too overwhelming so I ask for a little help :).
I have “Do” ...
Hello Justin and thanks so much for your detailed reply and help!
In fact, in the meantime I’ve got the knack of using nested IF-functions myself. At the time of my first posting I’d still been overwhelmed by all the parentheses :).
As for the “sorti...
Here’s an update on my behalf.
I’ve started creating the following formula, which works.
IF(DATETIME_DIFF(TODAY(), Deadline, ‘days’) >1, “Overdue " & DATETIME_DIFF(TODAY(), Deadline, ‘days’) & " days”).
By only adding a second condition (which doesn’...
