The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi all,
Trying to make an interface with a “maximum possible spend” for each project launch day. Projects launch twice a week and run from 2 days to 15 days. I need to find a way to ask the question “Is this project still running next Tuesday” and “i...
Okay so I solved this one myself using multiple formulae.
I started with this. That let me calculate when next Tuesday/Friday is in a way that Airtable understands.
I then created the following formula:
IF({End Date} = BLANK(),"False",
IF(AND({Next F...