Continuing the discussion from Auto removing a linked record when the record is removed from a view in the linked table?:
We’ve tried the above solution in an automation - it’s resulting in an error. The error is received invalid inputs. Any ideas ho...
Hi
I have created an asset manager in Airtable for our laptops and phones. Our leasing company has provided us with a grading spreadsheet for charges based on the grade of the laptops when they are returned to them.
I’ve got one table which is Asset ...
What would be the correct way to have the duration / age of a ticket in Airtable being any status that isn’t “Complete”?
In the “Days Open” field I currently have got to this formula :
IF(LAST_MODIFIED_TIME(Status), WORKDAY_DIFF( TODAY(), LAST_MODIF...
Hi @Justin_Barrett
It seems to work now but if I try another update (prior to the record being removed) - I get the same error. Trying to update said linked field status before removing it :
Can I type the status in or do I need to pick something fr...
I’ve now got to this formula :
IF(LAST_MODIFIED_TIME(Status) != “Complete”, WORKDAY_DIFF( TODAY(), CREATED_TIME({Date created})) )
It doesn’t seem to have changed anything and still giving me negative values in the cells.
I’ve considered this solution but it would still mean PDF’ing 3 different blocks and then having to merge them somehow.
We have to do this for 100 students a month - I can’t imagine someone doing that.
