I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and …
This one has me baffled. I have added a row to a large sheet. I notice it does not show up in any of my metrics calculations after the add. In my metrics sheet, I refer two ranges in another sheet: {A…
Hi all, I need to create a formula that will collect info from a different (original project) sheet and display the right data on the cell of a new sheet (used to build a report) - that way things sta…
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the…
I have a master sheet and want to feed multiple other sheets information from it. Master spreadsheet: is an employee roster, listing all employees and their status (active, inactive) Sheet 1: has a li…
Hi there! I’m sorry, but I’m very new to this platform and still trying to understand how it works. My employer has assigned me a task to improve the use and functionality of our worksheets. He sugges…
I have two items that are provisioned in Control Center when a user submits a new project - one is a checklist and one is the project team list. In the checklist, the role for each task is linked to t…
Hello, I would like to use a master list with a list of people attached to the department that populates multiple contacts in the same cell depending on what dropdown departments are selected. So Shee…
I'm noticing SEVERE delays with cell linking lately. As in over 15 minutes before the cell populates. Our plan includes tech support, so I called yesterday. They said "up to 5 minutes is normal" I'm a…