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.
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...