Best way to report a top of funnel of requests metric

jdawana19896

Hello, 

We are using Smartsheet as an intake form of new projects.  What I need to do is do a COUNT of all the projects that came in for this week and also by product type, and region request.  However, the only way I can think of doing this is to pull a report that looks at the created date and 7 days back, but I know you cannot create metrics off of a report. 

Does anyone have a best way of doing this? 

Shaine Greenwood

Hello,

I'd recommend looking into the COUNTIFS function, which will only count cells that meet multiple criteria. More info on this is available in our help center: https://help.smartsheet.com/function/countifs