-
Can you cell-link within the same sheet?
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 then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
I need a modification on an IF THEN statmenet
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 all children of that row will show "Task 2". I did that using this formula: =IF(Level@row = 2, LEFT([Task #]@row, 7),…
-
New reference range in a metrics sheet is not working.
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: {All Action Items Status1} and {All Action Items Resp Org Map}, which exist as a reference ranges. My original formula for…
-
Any idea what I could be doing wrong?
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 stay updated as the project progresses. So, a couple of things need to be taken into account, the info displayed needs to meet…
-
How to have multiple sheets show active items from a master sheet containing statuses?
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 list of required training and training expiration dates Sheet 2: has a list of company assets assigned to each employee I want…
-
Merged: certain cells remain locked until specific data is entered in another cell
This discussion has been merged.
-
Can I create a form that can automatically update a worksheet.
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 suggested that I explore the possibility of creating a generic form that can automatically populate client worksheets. The…
-
Cell Linking Multiple Cells with Control Center
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 the team list (so a person can be marked the Project Manager in the team list and all applicable tasks in the checklist will…
-
Return multiple contacts based on department dropdown list.
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 Sheet 1: Department Email Marketing Billy@help.com Operations Bob@help.com Sheet 2: Departments (dropdown multi select)…
-
Anyone else experiencing EXTREME delays with cell linking?
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 at over 15 minutes with no data being pulled down from the other sheet.