Is there a total row for the Smartsheet calendar?

mwat4482
mwat4482 ✭✭
edited 07/12/23 in Formulas and Functions

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

  • Genevieve P.
    Genevieve P. Employee Admin

    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

  • 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.
    Genevieve P. Employee Admin

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!