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?
Answers
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
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!
-
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!