Drop Down, and Auto fill cell wit color

klemenk

How do you setup a cell which has a drop down menu with 3 selections YES, NO, and N/A

What I want is:

If YES is selected the cell will turn Green.

If NO is select the cell will turn Red

If N/A is selected the cell will turn Yellow

Thanks

Andrée Starå

@klemenk

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Did that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @klemenk

I hope you're well and safe!

You'd use the Conditional Formatting function and set up three different rules, one for each scenario.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

klemenk

Yes, it does make sense but where, and how do I set up the formula this is all new to me.

Do you have an example or video as to how this is done?

Andrée Starå

@klemenk

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting

Did that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

klemenk

Thanks for all your help

Andrée Starå

@klemenk

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

klemenk

Hi, I was wondering if there is a way in Smartsheet's that I can link a specific file folder from my local network drive where we store all pertinent project documents, in to a project line in Smartsheet so when you click on it, it will go directly to that specific file folder within our local network drive.

Is this possible? And if so how would I set this up?

Thanks for all your help.

Ken