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

Find more posts tagged with

Project Management

Accepted answers

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!

All comments

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?

klemenk

Thanks for all your help

Andrée Starå

@klemenk

You're more than welcome!

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.