-
New Data not automatically subject to formulae
I have a sheet with hierarchies (up to two). There are multiple formulae doing their thing across; nothing fancy: sum and multiplication. As new data come in using a form, the new data are not subject to the formulae. It looks like I have to drop down and apply each formulae to the new data. This is cumbersome and seems…
-
Charts based on Pivot Table
Hello, I have a Pivot table. However, this always contains a Total column. I want to use this table as a source to create a chart. But I don't want to have the total column displayed in the graph. I didn't figure out how to remove it from the chart. It distorts the visualization. Is it going somehow? Thank you Hana…
-
Error when adding more than 5 logic rules
I'm trying to add rules to a form with logic. I had 5 rules added but when I try to add a 6th, i get the error "logic statement is too large. try reducing conditions for the affected fields." Is there a limit to the number of rules I can add to a form?
-
Accessibility / Screen Readers / WCAG Compliance / Mobile Responsiveness
Hi! I've searched the archives but haven't been able to find a clear answer. Is there a way to make a Smartsheet dashboard WCAG compliant/accessible to users with assistive technology? For example, can we get into the source code to create true H2s or add alt text? When I ran a quick assessment with Webaim's WAVE tool, I…
-
WorkApps re-opens Side / Navigation Panel on Refresh
While viewing a page in Workapps, and having already COLLAPSED the side navigation panel, if I REFRESH my browser tab to view updated data, the side navigation panel EXPANDS and I have to close it again. Any way to make it stop doing that? Upon refresh the page should remember the previous state: collapsed or expanded.…
-
Column formulas and Global Updates
Hi All! I've tried adding a new column from a template (with a column formula), but am getting an error. If I remove the column formula in the blueprint it works as expected. Am I doing something wrong, or has this not been updated in SCC yet? Thanks!
-
How do I pin Smartsheet to my Outlook dashboard
I've downloaded the Smartsheet Add-in for Outlook. Is there a way to pin it to the right on my dashboard? In the screenshot below, I have the Smartsheet add-in on the right. I'd like this to stay there. An other option, is the Gray bar just above the message. Currently it has "MessageFiler" as a quick click. Can that be…
-
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…
