Best Of
Ways to find what reports are running a certain sheet as it's source data
I want to make some structure change to particular sheet. (Especially Primary column) However, before I can change that, I need to find out how many and what reports are using this sheet as it's source to make sure nothing will break.
Anything used in cross-sheet reference formulas are easier to find out but Smartsheet support said there is no way to know what reports are running using that particular source sheet.
As we build more solution and share the source sheet with others, sometimes structure change is needed but I'd love to avoid breaking reports, so I'd like to find out before I make the change.
This function would come in very handy especially I inherited this sheet when I go hired.
Thanks!

Re: Change Formatting in Reports
Could use a more professional look with the ability to use color palettes for headers and fonts. Overall, it would be helpful to have more formatting options. I think it would be nice to match the reports to have a similar look and feel as the charts in dashboards.

Remove "Used in Formula" tooltip
This is just awful. It makes the sheet so cluttered and cumbersome.
Having a setting to toggle these off should be fairly trivial.
Generate Documents with Adobe Sign
Please add Adobe Sign as an option in the "Generate Document" feature.

Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional framework dimensions. Having the ability to customize the colors in sheets, as we can do now in Dashboards, would allow us to elevate our solutions for staff. Thank you for your time and consideration.

User Subscription Model - User Type and True-up Page Enhancement
Greetings,
When managing users within the User Type and True-up page of the Admin Center, the Highest Level of Permissions plays a vital part in establishing whether an Internal or External is considered as a billable Member, whether initially Provisional not.
While downgrading an External today from Provisional Member down to Guest, I was prompted to, "Select their new permissions level". The reason why this External was identified as a Provisional Member was due to the initial shared to Permissions having been set to Admin by the Owner of the shared asset, in this case a Sheet.
I would like to recommend that every entry in the "Highest Level of Permissions" column as listed in the User Type and True-up page be editable similarly to how the downgrading from Provisional Member to Guest for my External was allowed to be modified.
My ultimate goal is to eliminate Editor - Can Share. I want the sharing to be reserved for the Owner of the Asset or Workspace and/or departmental supervisor named as Admin by the Owner of that same Asset or Workspace.
Relying on Smartsheet users to adhere to a policy which states, when sharing only grant Editor - Cannot Share and below is impossible to maintain as an administrator over Smartsheet and its related costs.
Please vote for this enhancement. We need great controls to limit our cost exposure!
Thank you.
James J. Pstrzoch,
Directory of Process Improvement

Get the sheet name to reference it in automation email
Use case: User wants to setup an automation email where the sheet name can be referenced as a parameter in the subject and email text (e.g. {{sheet.name}}).
Current issue: It isn't possible to reference the sheet name in automation email.

Enable {{Curly Brackets}} in manual "Send Update Request"
Issue: {{Curly brackets}} don’t work in manually created update requests (right-click → "Send Update Request"), unlike in automated alerts. Instead of displaying cell values, they remain as plain text.
Current workaround: Manually copying cell data into the message, since all included columns in "Send Update Request" are editable.
Benefits of enabling {{Curly brackets}}:
- Saves time: Eliminates manual copy-pasting.
- Prevents unwanted editing: Keeps informative columns read-only (regardless of permission level).
- Improves consistency: Aligns manual and automated requests.

view as other user in dynamic view
I'm renewing the settings for our portfolio of dynamic views and doing some clean up. As I complete these tasks, I'd like to be able to "view as Amber" or "view as Anthony" so I can ensure my end users are having the experience I believe I've designed. Right now I'm temporarily assigning myself or having a colleague take screenshots so I can confirm what I think I've built, but can't see for myself.
Ideally this would an optional step in the set up before I save changes to the view. It would allow me to see projects assigned to the persons I'm designing for before I complete my work.

Re: February Question of the Month - Join the conversation and receive a badge
If you could create a new badge in Community, what would it be?
I would make a badge for a Smartie that shows to be active in Community boards on a consistent basis. However you decide to measure that, I will leave that to you but those who are always here being active, should be recognized as true Smarties. They may have started out here for just help or just a badge or two but they have learned to love it here. They deserve to be recognized. I sure do appreciate them.
