-
Card View in Reports
Is it possible to have Card View in reports? It would be great to be able to see a card view board for multiple sheets at once.
-
use logic formula to copy an entire line to another sheet
Hi everyone!. I´m from Argentina and 1)thanks for helping :) 2)sorry for my english! :( I need to learn how to use a logical formula in SHEET A to copy an entire line to SHEET B, if one of the columns of the line to be copied has a "R" status ("R" from "restriction" that line has) When entire line appears in SHEET B, I…
-
Datamesh Contact Lists
Hi, We are trying to use datamash to bring over contacts to the target sheet based on locations in a source sheet which does not seem to be working. We have multiple contacts enabled and this works fine with vlookup, but datamesh returns no results. Any Ideas??
-
See projects rolled up in a program gantt
Apologies in advance if this has been answered before - and I imagine it must have been since it seems a very obvious and primary requirement for managing projects in a business. Still, for something this fundamental I just can't understand why I can't see anything in the solutions centre or a search here in the community.…
-
Index or Vlookup or What?
Hey All! I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am wanting to pull data from the Budget cell based on the Job ID and the Cost Category. I'm not sure if it is a Index - Match…
-
Report Builder and Sheet Summary Report - Auto add new sheets
I successfully use the Sheet Summary Report - however, when I deploy a new Workspace, I must manually go back to the Report Builder and add the sheets that I want included in the Sheet Summary Report. Ideally, a Sheet Summary Report would look through ALL sheets, given my chosen criteria and return the results I'm looking…
-
Duration Vs Project Days
I have a project where the planned tasks are spread over several weeks, see attached. How is the summary % complete total calculated? Can I relate to %complete against project days? Regards Steve
-
Stuck trying to rollup with index, vlookup, and match
Hey folks, any idea how to pull this information onto another sheet horizontally? Basically, I am trying to consolidate some project information as seen in the "Source" screenshot. This particular sheet has the status for multiple items for the same project, but lists the same project on multiple rows. You can see this in…
-
Index Match Values Based on Certain Parent Rows
First, awesome community! I've been looking all over for a solution to my problem, but cannot find anything that would translate to my situation. Hopefully I make some sort of sense describing my issue. Brief: I work for a construction company that specializes in high rise construction. For my department, I'm tracking…
-
If and across sheets.
I am trying to write a formula that looks on another sheets row for an employee # and for a task code and then return the proficiency level linked to that task code. For further info I will try to explain my thinking. A trainer submits a form stating the employee #, SOP, and Competency level, to a sheet called "Training…
