So, I know that if you automate rows/cells to move to another sheet it removes links, but I have two sheets that are linked to one another that I want to archive and retain the links between them. Ide…
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and t…
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…
