-
Can't resolve view only status
My user is in view only and we can't change it. My user was granted enterprise access and I've request admin access and been assigned it but my user still is view only. I was able to to do everything and I had to renew my license on my user, which is fixed. Sheets that I had created I can't even edit.
-
Upcoming enhancement: Safe Sharing enforcement for dashboard widgets (effective Feb 23, 2026)
Summary On Feb 23, 2026, we’re rolling out a security enhancement that adds an additional entitlement check before sheet/report data can display in dashboards on another plan. If you embed a sheet or report you own into a dashboard on another plan (for example, a customer account) and Safe Sharing is enabled on your plan,…
-
Excel Tab Changes Impacting Data Shuttle
Hi - I have a data shuttle set up from a shared Excel file into a smartsheet that I use to basically alert me when changes are made to the excel by users other than myself. When I set up the data shuttle, the tab that I was referencing was Tab 1. Now the users have moved the tab and it is Tab 3. Do I need to update my Data…
-
Data Shuttle, Use sheet name to link which tab to reference
The tab number in Excel is easily changed and seems unreliable. In my experience, when the tab number does change, there isn't a method for Data Shuttle to alert you of any issue. It's typically an end user that alerts me that some data appears outdated. Preventing file changes in Excel would be one counter measure, but…
-
Set a value on one sheet if that sheet's row ID exists on another sheet with a certain status
I have Idea IDs that appear on two different sheets (sheet A, sheet B), and I have a column on sheet B called "Update needed?" Sheet A also has an Idea status column. I need a column formula for sheet B's "update needed" to be set to Yes if sheet A's Idea ID=sheet B's Idea ID for that row AND sheet A's status is "Not…
-
Range settings
=SUMIF({Stores Daily Log Range 8}, "1000000456", {Stores Daily Log Range 9}) Hi I am adding figures from the above sheet to another sheet using criterias. everything works until I add another line in the log then the Range does not automatically pick up the new line. Is there a way to do this please.
-
Comparing Three Columns
I have three columns that I want to compare. I thought an If(and( statement would do it but I keep getting #incorrect argument or #unparsable errors. Each column is a dollar amount and I basically want if Column 1 < Column 2 and Column 3 return a value. Below is the expression I've been trying. =IF(AND([EXTENDED COST…
-
The AI Agent gave instructions for Viewing as a User. Anyone able to get it to work?
AI Generated Response: To view Smartsheet as a specific user, you can follow these steps: In the Smartsheet web application, go to the Admin Center by clicking your account avatar in the bottom left and selecting "Admin Center." In the Admin Center, go to the "Users" section. Here you can see a list of all users on your…
-
Open Sheets in New Tab/Window from Reports
In a report, we have a column that links to all the project sheets that have been pulled in. When you click a link, however, it opens it in the same window, so you lose your place in the report. It would be great to have an option to click it and open in a new window or a new tab instead.
-
Grouping Hidden Columns+