•1 min read•from 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
Our take
Are you tired of cluttered spreadsheets that make tracking tedious? Transform your traditional Excel checklist into a streamlined questionnaire that dynamically adapts based on user responses. By using simple formulas and formatting, you can create a more organized and efficient tracking system that only displays necessary items when needed. This approach not only declutters your workspace but also saves you time and effort with each new tracker sheet. Let’s dive into how to leverage Excel’s capabilities for a cleaner, more functional solution.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Check-in list with multiple users, but each user only has access to their teamWe have a group of supervisors that are each responsible for their own techs. I'm looking to create a spreadsheet for the entire team, where each supervisor only sees their own group to check off. They would be responsible for the "Ops Check-in" and Notes column. https://preview.redd.it/p9o8mzljpwmg1.png?width=622&format=png&auto=webp&s=116a8270aba594b9c6ad84ff0d5425ae0dc94e72 Once they've submitted their team, another single person is responsible for the "Keyed" column. The fully completed checklist for the whole team would then need to be submitted by the person who keyed everything. From my research, I think my best bet is Power Query, but I've never used the tool. I've got all of the supervisors separated into their own sheets, and each sheet is formatted as a table, but I'm not sure where to go from here. I've also tried this in Microsoft Lists, but to no avail. submitted by /u/Uraqwik1 [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- Difficulty with checkbox and hiding rows.Admittedly I’m not great with excel. But I’m trying to setup excel in a way for people to simply click a checkbox on Sheet1, that would automatically filter or hide rows on sheet2, sheet3, and sheet4. Specifically I want to set it up so anyone in the field can open mobile excel on their phone or iPad, simply scroll down an input page with all options available, and quickly click checkboxes for items the customer needs. It will automatically fill data in on other sheets for all the formulas and outputs. And then hide rows on a summary page for the boxes that were not selected. Similarly, hide rows on an “estimate” page so the only rows displayed are the ones clicked. So all the field guys need to do is open mobile excel on their iPhones, click a few checkboxes, and the summary and estimate page will only show rows that were clicked on the input page. For whatever reason, I feel like I’m too dumb for this… so any help is greatly appreciated. Thank you submitted by /u/ALonelyTwinkie [link] [comments]
- Making a fillable form with dropdowns and sections that can be added and moved easily**SEE ATTACHED IMAGE** I am attempting to improve this spreadsheet. I have a decent amount of experience with Excel but I am unfamiliar with the terminology require to describe the exact functions I am attempting to implement. The function of the sheet is to log various statuses and information pertaining to ladders and their inspection status. Each workbook has a header section and a footer section to diffentiate between clients. The sections that detail the individual ladders need to be moveable / re-order more easily, and also be able to insert a blank ladder section for any new ladders that come into service. The reason excel was selected is for access reasons. All of our clients use excel, but if there is an objectively better tool for the job that is part of the Office suite that people can use via the web or with their Office licence then I will consider that. Thank you to everyone who is able to provide some insight into this. https://preview.redd.it/7ln3oocpcjvg1.png?width=1405&format=png&auto=webp&s=584525d55bd27779bd56a9d746b5dcc6dd913c70 submitted by /u/WillowDime [link] [comments]
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