Hey there, I’m using Airtable as a project tracker, and right now I have a field for “currently assigned to” and “historically assigned to”, that links my team table to my project table in the same record. The projects also have start and end dates, ...

I’d like a formula field to return =today() if another field is blank, but if the other field is already populated, to use that date instead. Any help crafting this?

Here’s my situation. I’m using Airtable to visualize information about my direct reports on an engineering team. It’s around a dozen people, all working on various things. I’m using Airtable to give me different views: for example, how much of th...