I have multiple sheet where data is coming through forms and each form has attachment option as well. My goal is to consolidate information into Master Sheet. I have successfully consolidated the information into Master Sheet but having problem with the consolidation of attachment. HOW CAN I CONSOLIDATE ALL ATTACHMENTS…
Hello all! I'm one of the solution engineers, and a provider myself (physical therapist), who helped develop this new HLS Solution Catalog. It interactive so you can drill into the solutions a bit (click on the images) to see a few of the use cases we commonly see. It's ever growing so continue to check back! What use…
I am trying to use a formula to: Referencing other sheet(s)… Sum story points by PE (Person) if: The Parent PCR (Identifier) is Unique The PCR Status is one of 5 options The PE assigned is an exact match (ie "Derrick Franklin") Here are a few that I feel are close, but not giving me the exact number's I'm looking for: This…
Help! I hit the 25000 cell limit when doing formulas .is there a work around or a way to get limit lifted with business license?
Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that serves as tracking tasks related to the projects in the master sheet. When People…
I have two "Slack Additions" and "Todays Location". Slack Additions is populated from a Slack Workflow. It is roster of peoples names, location, location start date and location end date. Names can appear on this sheet multiple times, with different locations for different time periods. I am trying to write a formula in…
I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to figure out how to count only a specific word in a cell when there are multiple valves in the cell. The formula I am using…
I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!
Hello, I am looking for help utilizing a formula to hide the #DIVIDE BY ZERO error message. My current formula in the "Change" column is simple: =([Availability %]@row - [Previous Availability %]@row) / [Previous Availability %]@row But for any cells in the "Previous Availability %" column that have 0%, I get the #DIVIDE…
I have a template that I created to use for several projects within my org. When I create a new sheet from this template my Duration and % complete columns completely break and do not work anymore. I have removed and recreated the columns to see if this will rectify the issue and it does not. No matter what I do I cannot…