Welcome!

Colour grading

Hi all,

Is there any way that i could, based simply on ascending order of numbers, colour code a full column, as i have in the picture below?

Thanks.

supplier colours.png

Manufacturing

Sheets

Formulas

Support

Hi Jose,

Unfortunately, it's not possible at the moment, you can only use the default colors, but it's an excellent idea!

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

IF Formula
I'm trying to set up a formula to calculate merit increases but, I keep getting "#UNPARSEABLE" in my cell. Can someone tell me what I am doing wrong? thank you! =if([Salary Per]@row ="Hourly",[Proposed Hourly Rate]@row *2080, if([Salary Per]@row ="Annually",[Current Salary Rate]@row *(1+[Increase Percentage Salary]@row…
INDEX or COLLECT with OR?
Pretty sure this a Friday afternoon brain lapse…. I need to pull a value over if one of two conditions is met. I need the {Request Number} from Sheet B IF [Case Number]@row matches {Case Number} on Sheet B OR IF [Person]@row matches {Person} from Sheet B. Thanks!1
How to pull cell data from one sheet to another based on criteria
I have a sheet that tracks census of sheltered animals and I want to display that census cell in another sheet that matches the room number. I had a formula that pulled that but another admin had accidentally deleted some columns/formulas. In short, I want the data from the census cell to be pulled into another sheet with…