Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Different sheets depending on the month

Hi Guys

Is there a way I can create different sheets depending on the month, like I want a sheet like the following…

If the sheet above is March I want a sheet to have 31 days on it and if the sheet above is February create a sheet with 28 days on it.

Maybe use Control Center? Please advise

Answers

  • Overachievers Alumni

    hi @Morena,

    yeah so SCC would definitely do that for you.

    You would just to need setup 12 blueprints for 12 months and each blueprint would have their own sheets with day numbers.

    In the intake sheet you would just use checkbox for specific month which would trigger the specific provisioning etc.

    it's pretty easy task.

    Tomasz Kowalski

    Experienced IT PM and the Real Smartsheet Enthusiast.

    Is there anything else we can help you with? - book your time.

    MASA Consult - Your Aligned Smartsheet Gold Partner

    Find us on LinkedIn & Check our Smartsheet Solutions!

    Tag my name: @kowal if you want me to respond :)

  • Community Champion

    Hi @Morena

    This may not be what you want, but I created this just for fun.

    If copied and set the Year and Month in the Sheet Summary fields, the sheet sets the month's dates automatically.

    https://app.smartsheet.com/b/publish?EQBCT=f0cf60e7b9a64d979eb34ccead6d43a3

    Formulas

    [Number of Days of the Month]# =IF(OR(Month# = "04", Month# = "06", Month# = "09", Month# = 11), 30, IF(AND(Month# = "02", MOD(Year#, 4) <> 0), 28, IF(AND(Month# = "02", MOD(Year#, 4) = 0), 29, 31)))

    [Month] =IF([Calendar Row]@row, IF(Month# = "01", "January", IF(Month# = "02", "February", IF(Month# = "03", "March", IF(Month# = "04", "April", IF(Month# = "05", "May", IF(Month# = "06", "June", IF(Month# = "07", "July", IF(Month# = "08", "August", IF(Month# = "09", "September", IF(Month# = "10", "October", IF(Month# = "11", "November", IF(Month# = "12", "December", "Invalid Month")))))))))))))
    [Date 1] =IF([Calendar Row]@row, DATE(Year#, VALUE(Month#), 1))
    [Date 2] =IF([Calendar Row]@row, [Date 1]@row + 1)
    [Date 3] =IF([Calendar Row]@row, [Date 2]@row + 1)
    [Date 4] =IF([Calendar Row]@row, [Date 3]@row + 1)
    [Date 5] =IF([Calendar Row]@row, [Date 4]@row + 1)
    [Date 6] =IF([Calendar Row]@row, [Date 5]@row + 1)
    [Date 7] =IF([Calendar Row]@row, [Date 6]@row + 1)
    [Date 8] =IF([Calendar Row]@row, [Date 7]@row + 1)
    [Date 9] =IF([Calendar Row]@row, [Date 8]@row + 1)
    [Date 10] =IF([Calendar Row]@row, [Date 9]@row + 1)
    [Date 11] =IF([Calendar Row]@row, [Date 10]@row + 1)
    [Date 12] =IF([Calendar Row]@row, [Date 11]@row + 1)
    [Date 13] =IF([Calendar Row]@row, [Date 12]@row + 1)
    [Date 14] =IF([Calendar Row]@row, [Date 13]@row + 1)
    [Date 15] =IF([Calendar Row]@row, [Date 14]@row + 1)
    [Date 16] =IF([Calendar Row]@row, [Date 15]@row + 1)
    [Date 17] =IF([Calendar Row]@row, [Date 16]@row + 1)
    [Date 18] =IF([Calendar Row]@row, [Date 17]@row + 1)
    [Date 19] =IF([Calendar Row]@row, [Date 18]@row + 1)
    [Date 20] =IF([Calendar Row]@row, [Date 19]@row + 1)
    [Date 21] =IF([Calendar Row]@row, [Date 20]@row + 1)
    [Date 22] =IF([Calendar Row]@row, [Date 21]@row + 1)
    [Date 23] =IF([Calendar Row]@row, [Date 22]@row + 1)
    [Date 24] =IF([Calendar Row]@row, [Date 23]@row + 1)
    [Date 25] =IF([Calendar Row]@row, [Date 24]@row + 1)
    [Date 26] =IF([Calendar Row]@row, [Date 25]@row + 1)
    [Date 27] =IF([Calendar Row]@row, [Date 26]@row + 1)
    [Date 28] =IF([Calendar Row]@row, [Date 27]@row + 1)
    [Date 29] =IF(AND([Calendar Row]@row, DAY([Date 28]@row) < [Number of Days of the Month]#), [Date 28]@row + 1, " - ")
    [Date 30] =IF([Calendar Row]@row, IF(ISDATE([Date 29]@row), IF(DAY([Date 29]@row) < [Number of Days of the Month]#, [Date 29]@row + 1, " - "), " - "))
    [Date 31] =IF([Calendar Row]@row, IF(ISDATE([Date 30]@row), IF(DAY([Date 30]@row) < [Number of Days of the Month]#, [Date 30]@row + 1, " - "), " - "))

Trending in Smartsheet Basics