Here's one approach that might work - 1. In Payments, add a formula to check if the date is in current quarter and format the output as single select options (Yes/No). e.g. IF(Quarter = DATETIME_FORMAT(TODAY(), 'YYYY-Q'),"Yes","No") 2. In Projects, c...
are you using a frontend (e.g. airtable interface, softr etc) or just directly in airtable? and are the links in URL fields or within text fields? if you have URL fields for the links you could add a button column that's linked to the url fieldor wit...
Would the below work for you? For #1 you could create an airtable automation:- Trigger: "At scheduled time" trigger (with interval type monthly, every 1 month on the 1st at 12am)- Action: Find records (where Send By is during this Month & Lab Status ...
not sure how your interface is set up but you could display 1 Task Due Date only, which is the formula (e.g. if manual, manual date, else project date). The Manual Date would be the editable one so either would need to display that too or in your int...