-
Combining Two Sheets into a Report
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - while continuing to maintain the two task list as separate sheets. I tried to create a…
-
Disable sorting for users, but still allow data entry
We are having a problem where accidental sorting occurs on a sheet used by several users, and I am looking to only allow users to enter data into a cell, but protect the placement of columns and rows. In my research I can not see a way to do this, because it is my understanding that if a row is locked, no data can be…
-
How best to link 3 columns from a mastersheet to a secondary sheet.
Hello, I've had a colleague come to me with a query about how best to link 2 sheets. Her enquiry includes a handy diagram: I'm wondering if cell linking would be best bet here? I realise this would obviously require her to keep having to action this for the 3 columns in question, when a new row of data is entered but it…
-
Is it possible to update a sheet by importing a new version of it.
Hi, Is it possible to update the information of a Sheet by replacing it with a new version of the sheet. In our current process, we have daily approvals, however by using an approval request or an update request, requires a lot of effort from the status owner e.g: 1.-Status owner receives "x" number of update/Approval…
-
Parent Row % Complete Doesn't make any sense
See attached image The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me. There is a formula for Target % complete: =IFERROR(IF(Status@row <> "Completed", IF(NETDAYS([Today (hidden)]$1, [Planned End]@row) /…
-
Metric Widget - Multiple Cell Display
I am pulling data from multiple cells within a Project Sheet. The issue is that for each cell, the information is being presented differently. In some cells, the data is presented BELOW the Cell Title while in other cells, the data is presented NEXT TO the Cell Title. Is there a way to have the data presented the same for…
-
Automatically update current stage
Hi, I am trying to track progress through various stages of publication (the columns titled approval, data collection, analysis...accepted). I thought the health bubbles may be a good way to quickly visualize progress but it is confusing the card view as it can only organize per specified column at a time. What would be…
-
How do I get the % to stay at 100% and not 150%?
How can I get the Completion Rate to only show 100% rather than 150%?
-
Sheet Linking
Is there a way to link one sheet to another sheet creating a drop down menu? Example: I am creating a form, but I want to the staff to be able to select the residents from a drop down menu. I have the sheet created with the residents information but I cant figure out how to link it to my "forms sheet' so that they are a…
-
Set up automated workflow to copy child rows to another sheet?
I have a sheet set up with parent rows for each month. I want to copy the child rows underneath the "July" parent row to another sheet using an automated workflow. What condition do I set if I want the rows under "July" to copy to the other sheet on the first of every month?