-
Work around for Data Shuttle not recognizing identical data
Hello! This is pretty hard to explain but I am hoping someone can help me with this dilemma: I am using Smartsheet to build a tracking system that monitors where field project workers are showing up on a weekly basis. I get the job addresses as a spreadsheet from another department. Since I am working with hundreds of…
-
Survey Help!
Hello All! I need your help! I need to send out a survey via email where I need employees to rank 10 different topics in a 1-10 format.
-
Merged: Make the Undo Button Active
This discussion has been merged.
-
Consolidation of Attachments from Multiple Sheet?
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…
-
SUM Rows in Column A that meet multiple criteria including distinct values in Column B
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…
-
Formula cell limit
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?
-
Dynamic Data Validation with Columns from another Grid
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…
-
Index column with multiple criteria
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…
-
What formula do I use to count a specific text when multiple text values are in a cell?
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…
-
Remove Primary Column From Report
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!