Sign in to join the conversation:
Hi,
in excel I have color scale option within conditional formating which highlights the top, middle and bottom results (you can choose raws columns of cells). How do I achieve that in smartsheet grid/sheet?)
You will need to set up each color scale one by one. There is no automated guess work like in Excel. You will likely need one or more columns to provide an easy sorting.
I might be tempted to build the scaling in a separate area, either on the Sheet or in another using X-Sheet References.
The LARGE, SMALL, COLLECT functions might be of help to create your criteria.
Check out the complete list for ideas:
https://help.smartsheet.com/functions
Craig
I have imported a fillable PDF form and have moved over all of the corresponding tabs. When I hit save to generate the form it get the following: To generate documents, please add some content to your sheet. Any ideas?
Hello, Our Task Tracker sheet is used to manage and collaborate on internal tasks. Each team member received a daily email containing all tasks assigned to them, and we all LOVE the update request feature where we use a webpage that resembles a form to review & update each request, click next, go through all tasks, and…
This is what I would like to accomplish using Smartsheets but I am struggling to find the best way to go about it. Each year we get new vegetable varieties that we need to test in various locations at different times. I would like a tool that I can follow each variety up with a grower. The following data is added:…
