Best Of
Personal Account for Fun (And Practice)
I am always trying to advance my skills and so, being the unapologetic Smartsheet buff that I am, I now pay for my own personal Smartsheet account to play around and practice my skills on personal projects. In my heart I would like to someday live somewhere else and to help me determine whereβ¦. I built a Smartsheet. Using formulas and conditional formatting I rank the data I collect on each city and then report it out in what I call my color map, with an overall rank based on the rankings of the other categories.
Alan Miller 11
Comments for Conditional Formatting
When creating conditional formatting, it would be helpful to have a Comments field where you could add context on what the formatting is indicating, and why it is doing it. This is helpful when you have multiple people that manage the conditional formatting.
See the attached photo for a mock-up of this idea.
jtallman
Re: December Question of the Month - Join the conversation and receive a badge
If you could create a new holiday, what would it be?
It features a handshake icon to symbolize teamwork and partnership.
Naeem Ejaz
Re: December Question of the Month - Join the conversation and receive a badge
I love sharing recipes! I just made a post in the Just For Fun about sharing recipes for the holidays! I try to make at least one new cookie or candy each year and this year I'm attempting 3 new ones. I usually make each close family member their favorite plus 1 or 2 for fun after that. I believe I'm up to 14 or 15 different kinds of cookies and candy this year π
Akblevins
Sharing a sheet via an automation
Would be great if it were possible to write an automation which would automatically share the sheet with people named in cells in the sheet. Ideally with controls to editing rights, etc.
Certain reports we make need to be shared with three particular individuals in the organisation but are intended to be confidential. At the moment, we have to identify them in cells in the sheet and then share the sheet with each of them. Too many operations, and too much possibility for error!
RRM
NEW! Real-time Inventory and Scheduling in Forms
Hey Community!
Your forms just got smarter! You can now use linked dropdown columns in your sheet to automatically hide options as they are claimed.
This is a perfect solution for tracking inventory or booking slots without worrying about over-selection. If you'd like to get this setup, all the info you need is in this help article.
This is the first version of this new functionality, and we canβt wait to show you what else we have planned!
Cheers!
Jason DelValle
Grouping Automations
I use many automations in some of my sheets and although there is sorting and filtering options to navigate between them (and I number my automations to help) it would be great to have a function where we can group them into folders or similar for ease of use.
Aussie
Bulk deactivation of automations
It would be incredibly useful to enable owners or admins to bulk deactivate automations within sheets. I'm currently having to manually deactivate 144 automations one by one!, the ability to 'select all' would be very useful when doing updates to my sheets.
Gillian C
Bulk Delete/Deactivate Users
Add the ability to delete or deactivate many users at the same time. Currently this has to be done one by one so this feature would save a lot of time.
Ty Hickman
Make fields required in update request workflows
When creating an automation workflow from scratch, where we request an update, is there any way we can make the fields that they have to fill out required? What we noticed when we did this was that multiple people were not completing all the information we needed them to, so when we would see what was updated in the Smartsheet and what was not, we would have to go back and follow up with them directly since something was missed. I know that you can make forms in Smartsheet and make what you want required, so I think this would be helpful when adding automation.
manjalteng