I have a dashboard showing a sum of specific values. I want to display the ending value each day so that I can see day by day if it has changed.

So today, we have 185 orders in review. I want that to automatically convert to a value only in another cell located on another tab once the date changes to tomorrow so I can see day by day if that number changes. The current value is using a count ifs formula.

Is this possible?

​I have a dashboard showing a sum of specific values. I want to display the ending value each day so that I can see day by day if it has changed. So today, we have 185 orders in review. I want that to automatically convert to a value only in another cell located on another tab once the date changes to tomorrow so I can see day by day if that number changes. The current value is using a count ifs formula. Is this possible?  Read More

​