-
Parents and children integrity
Hi I have a single sheet that has parents and children. What I was hoping to do is use Dynamic View to allow various people to add rows. I was hoping that it would automatically add/ categorize the rows into the relevant parent group. However when testing this it adds it to the bottom of the sheet. Is there a formula that…
-
Column and Row Transpose
To whom it may concern, It would be very helpful to have a simple feature to View Columns as rows and vice versa within a sheet. A simple setting to allow the column headers to appear as rows and row information to appear on top. With the associated cell data still in the correct position. Please and thank you. Kindly, Dj
-
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…
-
Automation Workflow Asssistance - Trigger based off Task's due date
Hello, Is there a way to sent an automation reminder to be triggered on my project plan for a task when another task's due date is 3 weeks out. For example, I have task A, task B and task C. Task B and Task C need to be completed before Task A can be completed. I am wanting to create an automation to notify the assignee…
-
how can I add on the roll up table my contact list of mangers so that the formula work
i have tried adding the email - the name but it doesn't work ! this is the formula I have used and referenced the assigned to and status column
-
Moving Comments Between Sheets
I am looking to find a method to copy select columns in a row along with the row comments from one sheet to another. Methods that I have tried and will not work in this scenario: Copying the entire row from Sheet A to Sheet B (This brings over all columns and I am only looking to copy over select columns) Using helper…
-
Merged: Conditional Formatting for Duplicates
This discussion has been merged.
-
Auto-Sorting sheet hacks
Hey guys! I've long been searching for a way to make one specific sheet auto-sort, without having to create individual reports. I know this has been a requested feature for ages and that it's in the works. I was curious if anyone has come up with any clever workarounds that can be used while we're all anxiously waiting? I…
-
Only Part of my formula is not working and I can't figure out why
I created the formula below and it is working for the section that says "Validations - Issue Validations" and "Validations - Regulatory Issue" part and I can't figure out why =IF([Risk Activity]@row = "Control Testing", IF([Actual Cycle Time]@row <= 75, "Green", IF([Actual Cycle Time]@row <= 90, "Yellow", "Red")), IF([Risk…
-
Group Rows Automation based on unique column ID
I am looking if there is a way to group rows that share a unique cell (i.e. Quote #) into one parent dropdown. I am wondering as a workaround due to the fact that the "Copy a row" automation from one sheet to another does not update the existing row but rather adds another row for the same quote ID # in this case. We are…