Type selected - allows certain columns to be updated

The checklist type smart sheet will be setup with columns called Vendor, Type, Doc 1, Doc 2, Doc3. What I want to do, is depending on the type selected for a particular vendor, the doc columns will grey out for those doc types needed for that specific doc type. For Example:

Vendor 1 Type Critical All doc type columns would be available to track collection of documents

Vendor 2 Type Important Doc 1, Doc 2 would be available but doc 3 would be greyed out (that document not needed for this vendor type)

Vendor 3 Type Incidental Doc 1 available, and Doc 2 and 3 would be greyed out

Anyone have experience or know if I can do this type of smartsheet?

Find more posts tagged with

Templates

Sheets

Formulas

Conditional Formatting

Comments

Andrée Starå

Hi Michele,

With a thought thru set up of Conditional formatting you could accomplish this.

Here's and example.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Sign in to join the conversation!

Quick Links

Trending discussions

Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Nested IF Statements
Hello. I cannot figure this out. =IF([GL Code]@row = 14030, "Leasehold") How do I add additional IF statements in the same cell, for example if the GL Code@row = 14040, "FF&E", GL Code@row = 14050, "CR Equip" Thanks.