I’m using Airtable to do some pipeline reporting and trying to create a field that shows the time a record has spent in its current stage. I have fields (all called “Moved to [Stage]”) that automatically get timestamped whenever a record moves into e...
Good catch, thanks. When I cleaned that up, Airtable still let me click Save, returned no error on the formula, and discarded it when I click Customize Field again.
I tried an alternative approach, which is a series of nested IF statements, but Airtable seems to be cutting me off at 2 nested IFs, even though I’ve read online that it supports more.
Here’s what I have that’s working for the first two stages:
IF({S...
{Moved to [Stage]} does not return a date. It returns text with the current stage name, which I in turn want to use to lookup the date in the field with the same name. Let me try and explain a little better:
I have a field called “Moved to SQL” which...
