Rebecca_Chapman - profile

Rebecca_Chapman · Jul 09, 2019

Hi - I am using Airtable as a project management tool, each task has start and finish dates (though sometimes the start date is blank) and there are 2 checkbox columns - ‘Started’ and ‘Done’. I’ve now created another column called ‘Status’ which I wa...

Rebecca_Chapman · Jul 11, 2019

Hi Justin, thank you so much for your detailed & thoughtful reply! I knew the formula was overcomplicated, but my brain was too scrambled to figure out how to simplify. You’re right that sometimes having no start date complicates it. The trouble is, ...

Rebecca_Chapman · Jul 09, 2019

Ok I have made it work but it involves 10 nested IFs!!! IF({Done?}=1, “Complete”, IF(AND({Start date}="",{Finish date}=""), “Timing TBC”, IF(AND({Start date}="", IS_BEFORE({Finish date}, NOW()), {Started?}=0), “Overdue!”, IF(AND({Start date}="", IS_A...

Rebecca_Chapman · Jul 09, 2019

PS I’m thinking I could avoid the error by dealing with each of the three scenarios where the start date is blank (ie. finish before today = overdue, finish today or in the next week = coming up, finish more than 1 week away = blank)… but it’ll make ...

User Statistics

User Activity

Troubleshooting nested IF formula

Re: Troubleshooting nested IF formula

Re: Troubleshooting nested IF formula

Re: Troubleshooting nested IF formula