-
Broken Pivot
When I go to refresh a pivot table, I get the following error: Error! The columnId 2691632771426180 is invalid. (1036) How do I figure out which column is the issue?
-
Formulas on target sheet not continuing when rows are added via datamesh
When a new row is added via Datamesh to my target sheet, columns in the target sheet that contain formulas do not trickle down. This is something that is a non-issue if data is added via a form so I'm having trouble understanding why it's not working in Datamesh.
-
Dropdown list - Update from the dev team ?
Hi everyone, TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used... I'm using Smartsheet more and more to provide simple solutions to my clients regarding their work (finance, managing team, project...). I…
-
WorkApps
Tried experimenting with WorkApps this weekend and I am super excited about it, but I do have quite a few questions and blockers at this point, who can I work with to try and get answers or resolution of the issues? I don't want to keep pasting them into new, individual messages and cluttering the community. But I do have…
-
Overlapping Labels on Bar Charts
I am using a stacked bar graph in order to show a breakdown of projected costs and where they come from. However, when using Data Labels, the totals and highest portion overlap. So far I have not been able to find a way to move labels around at all. I am specifically looking for a way to see the summed totals per month,…
-
Mail Merge with Form
Hi all, I was searching on the Smartsheet community, but i could not find the best solution for my issue. Basically, in my company, everytime that a production finishes, i receive via e-mail the test results for the specific product. With those results, later on, i must issue a document to the customer with those same…
-
Automatically copy specific fields from new rows in one sheet to another
Hi Folks, We have an intake sheet / form and a separate project sheet. Goal is to automatically copy specific fields from new rows in the Intake sheet (source) to a different Project sheet (destination) each time a new row is entered by users. When a new row is entered, we want to copy (as a new row) specific fields from…
-
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.
-
Document Management Systems
Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their implementations. (how well it integrates with SS, potential problems). It doesn't have…
