Create checklist that inserts list or keeps boxes empty depending on checked/unchecked
Hi all! I am trying to create an excel sheet for my job.
I need to turn tracking sheet with normal check boxes into a “questionnaire” type of spreadsheet where it asks ‘Does this person have X?’ , if the answer is ‘Yes’, it needs to populate a list of items that’s needed (there will be multiple questions like this).
The reason I need this is because the spreadsheet I have now is clogged up with all of the items in the list, whether the person needs it or not. I would like to make it cleaner, in a way that I don’t have to completely re-do the spreadsheet every time I have to make a tracker sheet.
Anyone able to teach me how to use formulas and formatting? Tried playing around with them and they don’t do what I need to do.
[link] [comments]
Want to read more?
Check out the full article on the original site