Hi there! I am a little stumped on creating these 2 formulas with a few different layers. All of my Commuity requests are about Iff statements- they hurt my brain, but I love them!
If an If statement is not the best approach, please let me know :sl...
Hi! Is it possible to set a time in a date/time function? I have a formula field that calculates due dates for tasks. I would like to create an automation that will email the task owner (a sponsor who does not have airtable access) a Google Calendar ...
Hi Airtable community! Hoping for some assistance with an If statement.
We have a workback schedule for deliverables based on an event date
Workback:Materials Due: WORKDAY(Date,-45))
Occasionally, we will need to adjust the deliverable dates if the d...
Hi! I’m trying to calculate a formula field that looks at 2 different fields (# Benefits Remaining) and (End Date) and returns either “Active” or “Inactive”. If the # Benefits Remaining is >=1 OR the end date is after today, it is active. Some of our...
It would be very helpful to have the ability to customize the Record view to move fields around, create fields next to each other and create sections. Drag and Drop would be ideal.
Thank you for breaking this down. I thought that I would have to create a third Deliverables Date field but the formula you sent me works perfectly and makes sense!
