![]() 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 |