I am trying to create a FIFO roster within Smartsheet so we can move away from the manual Excel spreadsheet. Any ideas how I could do this?
Hi @Clare C
I would suggest setting up your Smartsheet sheet in an opposite way, where your Names are the columns and the first column is a Date-type of Smartsheet column where you list out the Dates/Months. See: Column Type Reference
Perhaps something like this:
In this sheet the "Month" column is the Primary Column, which would allow you to minimize each month section as needed:
However if you want to use the Calendar View, what I would do in this instance is have the Month column be a regular Text/Number column (or even only use the Date column and adjust the formatting), then use a formula to return the name of any person who has data in that row into the Primary Column.
For example, something like this:
That way their names will show up in the Calendar View, so you can quickly see exceptions per-day:
Thanks Genevieve they are some great ideas! I'll give it a go!
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello Smart-Heads! This one might sound trivial, but I am looking for an automation to copy limited amount of information from one row to a new row in the same sheet. The sheet contains initial generic information. Column E can be duplicated across the sheet with unique values from column F, assigned to column E, example:…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.