Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Color Coding for Names / Owners only

I'm trying to find out if I can color code only the name bubble.

For example, below I'm using the multiple-drop down column formatting and all names are shown in grey. It would be nice to show Whitney in purple, and Laura in yellow, so that they can quickly see tasks they are assigned to.

Right now, I can only set a conditional format to the column, and if there is more than one word and format, it defaults to the first rule (so both names are purple).

I know that I can set the column up as a Contact List instead of multiple drop-down, but then the names are too long and you either have to scroll across the whole sheet, or have rows different heights and not all able to show on one page.

Thanks!



Owner_Smartsheet.PNG


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions