Otto_Kiefer - profile

Otto_Kiefer · Jul 16, 2020

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” ...

Otto_Kiefer · Jul 29, 2020

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...

Otto_Kiefer · Jul 16, 2020

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’...

User Statistics

User Activity

Conditional formula to show status based on date

Re: Conditional formula to show status based on date

Re: Conditional formula to show status based on date