1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/Puzzleheaded-Dot6895
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#Excel compatibility
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#real-time data collaboration
#Excel
#spreadsheet
#formulas
#formatting