Here are my top tips for creating long-lasting, friendly and useful trackers. Trackers are a big part of spreadsheet life. Just set up rules to highlight the Status column based on what matters to you.įor example, if you want to highlight all “Read” statuses, you can use below rule. You can use conditional formatting to easily spot these. is fussy about the SOP status and want to quickly monitor anyone not starting the SOP process or half-done it. Step 3: Highlight what matters with conditional formatting This is similar to the rule for “Type” column. Once the named range is created, use it as List for data validation on the Department column as shown below.ĭata validation rule for “SOP Status” column: availableDepts named range (Formulas > Define Name) like this: We can use the trusty IF formula for this. Now, we will create a dynamic named range that will return either lstDepts or blank depending on what is picked in (the current row’s type value). Start by setting up a list of departments in a range and give it a name like lstDepts We want to show a list of departments if type = Full time or Temp. Data validation rule for Department column:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |