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.

Find more posts tagged with

Healthcare

Formulas

functionality

Project Management

Accepted answers

All comments

Andrée Starå

Hi Martin,

Try something like this.

=SUMIF(Date:Date; TODAY(); Census:Census)

The same version but with the below changes for convenience.

=SUMIF(Date:Date, TODAY(), Census:Census)

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma."

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or 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!

Martin Youschak

Hi Andrée Starå,

Thanks for the comment; I did manage to finally solve my problem late last night.

Here's what finally worked.:

=SUMIFS(Census:Census, Date:Date, TODAY(0), ServiceLine:ServiceLine, "Home Health")

Have a great weekend yourself,

Andrée Starå

@Martin Youschak

Excellent!

Glad you got it working!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.