-
Creating unique participant IDs
Hi all, I am looking for a way to generate unique IDs for individuals filling out forms. We have a number of events for which we have made registration forms. When a person fills out a form, we would like to have the corresponding sheet automatically generate a unique ID for each person that is de-identified. Is there a…
-
Display date and duration by referencing other cells in the same sheet
Hello Everyone, I'm trying to reference data from row 44 into row 3 in the same sheet. "=[Task Name]44" works like a charm (see below). However, =[Start]44 doesn't result in the date "08/13/25" being reflected in row 3. Likewise, =[Finish]@44 doesn't reflect the Finish date from row 44. =[Duration]@44 or =Duration44…
-
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…