Best way to report a top of funnel of requests metric

jdawana19896 ✭✭
edited 12/09/19 in Formulas and Functions


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? 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!