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
-
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.
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 :)
-
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.
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, " - "), " - "))
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.3K Get Help
- 462 Global Discussions
- 156 Industry Talk
- 508 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 517 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives