After that, select cell B7 and write down the following formula.Now select different category values from the Tables sheet and press Enter.Next, in the Data Validation box select List under Allow in the Settings tab.Under the Data Tools group, select Data Validation.Let’s name the sheet Pending Tasks by Category. First, create a new sheet and create all the headers in it.To get those in a new spreadsheet, follow these steps. If you want all the pending tasks of a specific category or all the urgent pending tasks. Step 3: Creating Pending Tasks Using Different Parameters Read More: How to Create a Progress Tracker in Excel □ FILTER(Tasklist,(AllTaskList!B:B0)*(AllTaskList!G:G=”Not Done”)) returns all the row values where both the above conditions were TRUE. □ Similarly, AllTaskList!G:G=”Not Done” is a condition and returns a boolean value. □ AllTaskList!B:B0 is a formula to express a condition and returns a boolean value. =FILTER(Tasklist,(AllTaskList!B:B0)*(AllTaskList!G:G=”Not Done”))
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |