-
Automate Update request gives access to view entire sheet
Is there a way of using automation for update request without giving the assigned person view access to the entire sheet? I don't want to do manual requests on each row. Also if they are not a viewer the automation fails. The email that goes out has 'go to the sheet' on the bottom which allows them to view the whole sheet…
-
pivots and access permissions
does anyone have experience and solution for a failure of the pivots app to create ''accessible'' destination sheets in workspaces that I own? The pivot creates the sheets, but will not run, and informs I have no permission to access the sheet. pivots and sheets previously created are still working OK, updating hourly.
-
Rotating Assignee on weekly basis
I’m building a Smartsheet to rotate 30 assignees on a weekly schedule, with each task spanning one week. The formula I created is returning a ‘#UNPARSEABLE’ error. Could anybody advise on how to correct it or recommend an alternative formula that supports this rotation? Any visuals appreciated as well.
-
RACSI/RACI Matrix with Conditional Formatting
Does anyone have a solution to easily set up conditional format for a RACSI/RACI Matrix without having to clone each RACSI option and setting up a conditional format for each role (in columns)? Like a formula or selecting multiple columns with the same dropdown? I created a traditional RACSI matrix for a customer but got…
-
Sheet Statistics
Something that quickly shows # of rows # of columns # of cells # of cross references # of unique formulas I'm sure there are other metrics that would be nice to see quickly Close to breaking warning or notification to sheet owner Could be part of Work Insights but all together, like a table, and update immediately.
-
Make Cell Usage and Formula Usage Counts Visible
When troubleshooting issues with data limitations, I often need to check with a Smartsheet specialist about the number of cells used on a sheet. They will be able to refresh a view and find this to compare to my calculations of rows X columns and/or the little gray tooltips displaying in the bottom-right of a sheet when…
-
Formula Entry Formatting
I'd like to suggest an enhancement for the formula bar in Smartsheet. As it stands, users are unable to expand the formula bar or input/format multi-line formulas directly. This limitation is particularly challenging when dealing with complex formulas, where keeping track of parenthesis pairings and overall structure is…
-
Sheet Vs Workstream permissions to external users
Hello, My non-profit has some auditors in the office today and they are reviewing some of our project plans as part of the financial audit. To be most efficient I have been asked to give them access to a particular project sheet. However I can't see to be able to share an individual sheet (the 'share' button is greyed…
-
Merged: Dynamic View - add sheet attachments
This discussion has been merged.
-
How do I stop rounding?
Hello! I'm trying to enter tax information for different counties. I need this amount to be 2.0145%, but it keeps rounding to 2.015%. I've added two extra decimal places, and it still rounds to the thousandths place. How can I get the full number to show?