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 set up a form with conditional logic to display the fields I want to display upon select criteria and that is working. However, at the beginning of the form I only want 2 fields to display and the rest to be hidden. Based on the below logic I thought the form would only show the first 2 fields selected but that is…
Hello, I am not sure i understand what the scheduler means in the data shuttle I have set up. Does the below mean that my scheduler will run every hour from 5 am to 8 pm each day? I need it to update often but not sure if this will do it or not. Thank you to those that are smarter than me :-)
I have requested for a snapshot, but I have not received the email yet. Any idea why and what do I need to do?
