Help with SUMIFS formula to display todays census

Hello,

Every day three service line VPs complete a SS Form. The form's information indicates todays date, service line, and a census.

I need a formula (I presume =SUMIFS) that tells me the census for one of those service lines for only 'today's date'. That sum then flows to a dashboard widget so leadership can view only today's census for each of the three service lines.

I wrote a similar working function in excel; but I am have trouble replicating in Smartsheet.

Solving this will greatly help our teams COVID-19 response.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!