Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 20, 2022 09:09 AM
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 built a table and created a form for people to submit their issues but now I need to track how long it takes the team to complete a ticket. I would like the days-old filled to stop counting once the Status field equals complete.
Would anyone be able to help me with this? Below is a screenshot of the modified bugs template that I've been using.
Dec 20, 2022 09:55 AM
Hi @athomas
This is easy, just add the following formula to the start of your Days Old formula:
If(Status="Complete",DATETIME_DIFF({Open Date}, LAST_MODIFIED_TIME(Status)
Please adjust the field names as I couldn't copy them correctly from your screenshot. (If you have trouble with the formula, feel free to share your current formula so I can adjust it)
Dec 23, 2022 07:44 AM
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?