Is there a total row for the Smartsheet calendar?

I'm trying to get a row in the smartsheet calendar that shows the count of runs per month. Is that possible? Right now I have tasks grouped under a common name, and had to create two extra columns, Month of Start Date

=DATE(YEAR([Start Date]@row), MONTH([Start Date]@row), 1)

and Runs in same month

=COUNTIFS([Project Name]:[Project Name], [Project Name]@row, [Start Date]:[Start Date], IFERROR((MONTH(@cell)), 0) = IFERROR(MONTH([Start Date]@row), ""))

I'm trying to get a calendar view that has the runs in the same month separated by project name, and then a final row that has the subtotal of runs for that month. I can make that as an additional column, but how do I add it to the calendar?

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @mwat4482

I may be misunderstanding what it is you're looking to do, but with those columns you could set up 2 Grouping levels in your Calendar view:

Project Name
Runs in the Same Month

Then if you have the Total Runs in Month set as the Task Name, this will appear bolded in each of the cards:

There currently isn't a way to add a third Grouping the Calendar App, if this is what you were looking for. Let me know if this helped!

Cheers,

Genevieve

mwat4482

Hi, I don't think this is necessarily the answer. What I'm trying to get is something like the below (excuse my paint handwriting)

Is there a way I can create a helper row that shows that and I can include it in my calendar?

Thanks!

Genevieve P.

Hi @mwat4482

Thanks for clarifying, your example really helps!

No, there currently isn't a way to have a "totals" row like that. Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!

Cheers,

Genevieve

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.