I have work queue and status column. I would like to count the number of items that are closed (daily) or today. I understand this number would change throughout the day. Can someone assist? Thanks!
Try something like this.
=COUNTIFS(Status:Status; "Closed"; Date:Date; TODAY())
The same version but with the below changes for your and others convenience.
=COUNTIFS(Status:Status, "Closed", Date:Date, TODAY())
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did that work?
I hope that helps!
Have a fantastic week!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Ah...thank you! That works!!
Happy to help!
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
We had an employee leave and we are unable to edit the fields directly in the smart sheet. They had some kind of system set up where their fields were being populated via a dynamic view. I can not longer access this view because the person in question left our org. Is there a way to get access to that view now their…
Hello everyone, I'm wanting to run a workflow once every three months. If I set the trigger to be the first Monday of the month, every three moths, and starting today, will it trigger in three months' time on the first Monday? Or will it trigger next month's Monday (assuming this month's first Monday has already passed,…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.