Hello I am trying to leverage MS Teams as a OneDrive sharepoint file location for DataUploader to use for scheduled uploads. DataUploader recognizes the file location and tries to grab the specified .csv file. The .csv is useable - I can manually attach the exact file to a sheet and DataUploader executes. This is the error…
Greetings - I'm experiencing some inconsistencies between my Pivot Sheets relating to column name changes. The pivot process adds "Grand Totals-SUM-" as a prefix to the column name. I remove it and run the process again. The pivot process works fine on some sheets (data loads as-expected). However, brand new columns are…
Hi, has anyone had trouble archiving a project? I have archived several projects lately but one closed project will not archive. thx!
I have a dynamic view tied to a sheet where the General permissions are such that access is restricted based on a field I called Primary Customer Email. My understanding of Dynamic View was that I could then enter the email of a non-licensed viewer (a customer in this case) and they would have access to their row(s) of…
Hi All! I experienced this quirk when trying to apply a global update, and can't think of a good workaround. I have a dropdown list where a couple of values have commas within the line. When I try applying a global update to add values to the dropdown list, SCC is automatically splitting these up into 3 separate values,…
Has anyone found a way to display a Smartsheet pivot table on a dashboard? I have created a pivot table that summarizes my data, which include multiple lookups and would like it to appear on the dashboard.
Hi all, MY font sizes and weights are coming out different for different column entries when I drag them into the fillable spaces. I have made all of the font weights and sizes uniform in the original fillable PDF, but still the same outcome. Forgive the ignirance, but is there a place in Smartsheet that I can alter the…
I'm trying to run a datamesh over a column that has a formula entered in. The column is supposed to show "N/A" through the formula until there is data to copy over from the source sheet. I want the Datamesh to copy over the formula, but instead it shows a red triangle in the details of the datamesh config. Is there anyway…
Hi, I am trying to fetch a value based on three columns the columns are as under: I am trying to filter out how many requests are there in the two types against each "LOB category", I tried Count IF and phrased it as : =COUNTIFS({DocRequestTypAPAC}, $[Document Request Type]@row, {LOBIRS} = "IRS", {RRmnth}, "October 2020").…
Adobe just did a major update and the extension is no longer compatible with the latest version of the software. when will we be able to see an updates version of the extension so I can continue using it?
I am building a one stop shop Dashboard for Productivity. Anyone been able to pull in a Lucidchart Process Map or Data Flow Chart? The team leans very much to a more visualized process interpretation.
Hi team, I have a sheet in Smartsheet which captures data via form and also know wanted to update with data from excel. For this I have created upload workflow and have attached one drive excel attachment. I do not really have ID column within my sheet, because the participants who are completing the form do not know this…
There is a long story behind this but I need to change the name of a Parent project in control center. Without doing this the children projects are not launching. Any suggestions would be greatly appreciated.
Help shape the future of Smartsheet. Share your ideas and feature requests.