Status change and day counter

cpezz ✭✭
edited 12/09/19 in Smartsheet Basics

Hi all,

Is there a formula I can use so that when I change a status in one of the columns, a day counter in another column returns to 1 and starts counting? For example, if I have an entity in "processing" and in another column the number of days it has been in that status, when I change it from "processing" to "complete" that the counter in the other cell will return to 1 and being counting the days in that status?