Hello All,
I am wondering if there is a way to automate this process. I am trying to get a count of each line item status type at the end of each day. Currently, I am updating a master sheet that has a status column reading either “active” or “not active.”
At the end of each day, I am manually totaling the number of active lines and inputting it into a separate sheet which feeds into a trend summary (line graph in picture). Each data point is the final count at the end of each day.
I am looking for a way to automatically count the total active cases at the end of each day. That can automatically feed into the trend summary.
Is this doable without 3rd party software? How does this need to be set up?
Thank you!