-
Assessing .csv from MS Teams
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…
-
Should I be able to share a dynamic view with a free-user license
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…
-
Pivot Sheet Column Name Changes
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…
-
can we control how fields from Outlook populate the sheet?
for example, I created a request portal which contains a column showing who made the actual request. I prefer to have this column auto populated from Outlook based on who's in the "from" field. Do we have any control over this? thank you
-
Email import via Zapier
Hi I am auto-forwarding certain emails from Outlook to a Smartsheet list via Zapier. Everything comes across fine but certain data fields seem limited in space. The body of the email doesn't fully transfer. It seems there is a character limit to either the Zapier forward or to Smartsheet. How can I get the complete email…
-
Date field will not show any data
Hi, I have a date field that will not accept any data. If I type anything into it, it disappears after 1/2 second. The cell is supposed to get it's date from the predecessor column. This line should start the same time as the predecessor. Code in the predecessor column is "7SS" which should mean that THIS line starts the…
-
Using Datamesh to copy over an existing formula
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…
-
Global Update Splitting Comma Seperated Values
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,…
-
Due Date alert?
Is there a way to send a message to someone when an action item is due in one week? Thanks in advance. bob
-
#INVALID OPERATION while using COUNTIFS
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").…
