Hello, I need to create an aging formula with an If statement to track when a record is open with a count of days until it gets closed and ultimately stops counting. I then want to be left with the difference of days between the date opened and the ...
Hello Community! I have to preface this request by saying that I was asked to come up with a way to track issues, stumbled across Airtable, and purchased an account. Airtable has been a lifesaver but I have zero knowledge on how to create formulas.I ...
I'm having a similar issue but am using a form, so I'm unsure where to go next. The automation is triggered when the form is submitted. The automation sends the submitter of the form a confirmation that the form is submitted. The run history shows th...
@TheTimeSavingCo Thank you again! I think I was trying to make it too hard. LOL. So I ended up with three date columns. (Opened Date, Date Closed, Days old) I changed the formula in the Days old column to be DATETIME_DIFF({Opened date}, {Date Cl...
