Having a comment section inside of a sheet
I currently have this sheet below. Some explanation, It is used to track visitors and this acts sort of a metric sheet for a dashboard I have set up displaying the numbers. The user just puts in a number in a cell corresponding to the number of visitors.
Visitor Count row is what is actually pulled into the dashboard. The True Count row is just for the person running the sheet to keep track of a true count for a set of rules that needs to be followed.
I have automation set up that clears all of these cells that I will also include below.
What I am wanting to add is a comment section that the users can leave information in to transfer info to whoever is coming in for the next shift.
I know that Smartsheet has the "Conversations" tab that would allow for this but I want it to be super user friendly for the person who runs the sheet during the day. I also want the cell/cells that comments are left in to clear each morning just like the cells if possible which is another reason I do not want to use the conversations function.
Anyone have any ideas on how to have a sort of "comment section" within the sheet that would be able to clear and also look ok within the format I am currently using?
Answers
-
Have you tried just adding in a text/number column?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
How would you set this up automation wise? Can I just add an existing condition on the ones I already have?
I just want the notes to automatically clear with the numbers each morning but keep the cell obviously.
Always appreciate your help!
-
Yes. You would set it up exactly the same as the rest of the cells you are clearing out.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives