Help

Stop "days old" count when status equals complete

1561 2
cancel
Showing results for 
Search instead for 
Did you mean: 
athomas
5 - Automation Enthusiast
5 - Automation Enthusiast

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. 

athomas_0-1671556159419.png

 

 

2 Replies 2

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)

 

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? 

athomas_0-1671810244772.png