athomas - profile

athomas · Jan 09, 2023

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

athomas · Dec 20, 2022

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

athomas · Mar 08, 2024

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

athomas · Jan 10, 2023

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

athomas · Dec 23, 2022

hi @Mohamed_Swella1 ! Thank you for taking the time to help me. Question, when I add the formula I'm getting an error message: How do I resolve this?

User Statistics

User Activity

aging formula, difference of days between date opened and when records status = complete

Stop "days old" count when status equals complete

Re: Automations Not pulling Values from Table

Re: aging formula, difference of days between date opened and when records status = complete

Re: Stop "days old" count when status equals complete