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 a Smartsheet automation setup to reminder the planning to complete their sections. It is setup to remind weekly until completed box is checked. They received 2 reminders and then the reminders stopped. Any idea what could be wrong? I can't tell that anything has changed in the sheet. Thanks Freda
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
I am trying to create a workflow and for some reason it gives me an error with the email I entered as the recipient for my Alert. It is an email that I know works, it is shared to the sheet, and the access to the sheet is unrestricted. I am perplexed at what the issue is. Anyone else get this and know what the issue is?
