-
URL Query string did not move with "Save as New" How to remedy?
I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I created a form and appended a query string to the form URL such that when a person clicks the URL, information from the URL…
-
Compiling Inventory Data Living Across Multiple Columns
Hi everyone! I am in the process of creating an inventory tracking sheet. Long story short, i built a form to keep track of inventory being taken out, and it offers 5 chances (so they drop into 5 different columns) to track any products counts taken out. I would like to be able to take those 5 numbers and compile them into…
-
Formula cross referencing sheet via template
Hello! I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all works great with the exception I have one formula that uses a vlookup to tell the status…
-
Where can I find a smartsheet's consultant??
Looking for a consultant to help our business maximize how we currently use Smartsheet. Needing someone with expertise in offering opinions and solutions for our needs. We are wanting to revamp our processes and utilize the dashboards, reports and automations. Would love someone that will offer guidance and that will build…
-
Referencing data from other sheets
I need to create a sheet (let's call it Sheet 1) that references data from several other sheets IF a certain box is checked in those reference sheets. For instance, If the box is checked in any row of column B, Sheet 2 or column D, Sheet 3, the data from the Name, Date and Amount column for that row in those sheets would…
-
Totaling across summary sheets
I have created summary sheets in several of my departmental sheets to take the place of the metric section at the top. How can I summarize across all of the summary sheets? I see I can pull them into a report, but I cannot add a Totals or Average field summarize across the summary sheets. I thought I would simply add a…
-
Changing Status Based on Another Sheet
Is there a way to link a cell from sheet A to respond to a change in Sheet B? For example, if I change a cell in sheet B to "under review by editor" could I change a corresponding cell in sheet A to "In Edits"
-
SUMIF Children, Referencing Another Sheet
I am creating a summary sheet and would like to include a sum of course developments by college. I know how to do a SUMIF in general, but can I use the CHILDREN function to sum (or count the number of instances) of courses/payments based on the value in the College column? Source Sheet The parent is called 201910, and all…
-
Pivot: Add Row Links from source sheet
We're starting to dive in a make use of the Pivot app, and it is extremely powerful, however we are finding that it would be extremely useful for users to be able to affect the base data from the Pivot sheet more easily. One idea I have would be if there was a link in the Pivot sheet for each row directly to that row in…
-
How do I have a Dashboard show only 100% not 150%
Please see below example. I want to only show 100% as the top, not 150%. Is that something on the sheet itself that I need to do? If so, I only have a % Complete and % Remaining columns. What would i need to place in there to fix this.
