-
Automatically enter category into cell
Sorry, I do not know how to say this. I would like to see if there is a way to automatically enter the category name into a cell. (see image) I've manually put the category in the highlighted box but I'd like to see if there is a faster way? Thank you
-
V lookup in sheet summary
Is there a limit to the number of V lookup reference sheets I can use on a sheet's summary tab? It seems like when I change a field to reference 'Sheet A,' and save, the other fields also change to 'Sheet A' even though I indicated 'Sheet B' for that field.
-
Fixed Cell Reference
I have search the db for answers but likely have my terminology mixed. I have a sheet which is populated by clients via a web form. New entries appear on the 1st line. I want the value in 'Bears 1' to populate in another sheet or on the same, doesnt matter. The specific cell is key as this is the most current value.…
-
Report not Matching Formula Issue
Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You will see on here that there is: * 3x for the FASTRACK Workshop * 10x for the Van Workshop *…
-
How to "actualize" or transfer dependencies of a completed task?
Task A Task B is dependent on Task A Task C is dependent on Task B For some reason, I was able to finish Task B and Task A was getting delayed. How do I: 1. Extend duration of Task A without impacting dates, duration or status of Task B? 2. Mark Task B complete, such that actual completion dates do not change irrespective…
-
Multi-sheet Kanban
We use a checklist with 340 lines. We currently create a new sheet for each project. We would like to create a kanban that links these projects utilizing the highest level of the hierarchy as the lanes (5 lanes) and the next level as dropdowns in the cards (9 at the most.) The third level is where the actual tasks are but…
-
Formulas In Templates Reference to another Sheet
Is there a way to save a sheet as a template that has formula references to another sheet and be able to easily change the reference when using the template? I have a summary and detail sheet that I want to create a template for future use. The summary references the detail. I'd like the Summary sheet to maintain links to…
-
Reference main table to populate a new subset table based on conditions
Hi, I created a workspace that contains a list of project folders (and its respective sheets, reports and dashboards). I'm looking to produce a new consolidated Master sheet based on multiple criteria from each main reference sheet found in the workspace. In the simplified example attached, the new master table must be…
-
Calender based on a report
I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either A: Be able to format the calendar on the report(I know that reports…
-
Links in Dynamic View Work Around
Has anyone figured out a workaround to putting links into dynamic view. I am using control center to create a hyperlink to another sheet with display text (for example "West Coast Project List"). This type of hyperlink does not show up in Dynamic View. I am trying to find a work around and was wondering if my best bet was…