Best Of
Issues with Notification color/branding
Hi all - just thought I would float this here first to see if anyone has had similar experience (and any fixes), before sending a ticket through to support. Have a basic automation notification set up with a company logo and task bar color in place. All has been working great but today it won't include the company logo or task bar color. Screenshot below - image on the left is 4 weeks ago and image on the right is today. NOTHING has been changed (ie, Workspace Colors and Logo settings etc). I have logged out and logged back in but still no success. Anyone has similar issues….or support ticket time??
Re: Start Date Formulas not appearing in reports
@khasimbashashaik If you are using AI in your responses, please verify the response before posting. There is no TEXT function in Smartsheet. The formula in the original screenshots also shows that none of those things are being used.
Paul Newcome
Re: May Question of the Month - Join the conversation and receive a badge
Hahaha. I don't think two orders will be enough.
Paul Newcome
Re: Current User Report Filter to Include Group Memebers
I've done something similar, If you've got your sheet or relationships between Users and assistant ready (Column 1 = User, Column 2= Assistants, multi-contact), then all you would need to do is add the "assistant " column into your target sheet and use an INDEX/MATCH formula to bring them. Then just add an OR assistant = Current user filter to your report.
Enhanced Governance Controls for Native Smartsheet Access Requests
Problem Statement
Currently, Smartsheet’s native “Request Access” functionality provides very limited governance and administrative control for enterprise environments.
When users request access to a sheet, report, or dashboard:
- The permission level is automatically predetermined (commonly Editor)
- Users cannot specify the level of access needed
- Business justification fields are optional and cannot be enforced
- Admins cannot customize or standardize the request workflow
- Event Reporting lacks sufficient contextual data to support governance auditing and security reviews
This creates operational and compliance challenges for organizations attempting to manage access at scale.
Requested Enhancements
1. Allow Users to Select Requested Permission Level
Provide configurable access-level selection within the native request dialog, such as:
- Viewer
- Commenter
- Editor
- Admin
Admins should also be able to configure which permission levels are requestable.
2. Allow Admins to Require Business Justification
Provide the ability to make the “Reason for Access” field mandatory.
Additional enhancements could include:
- Minimum character requirements
- Custom prompt text
- Conditional requirements based on permission level requested
Example:
- Viewer access → optional reason
- Admin access → mandatory business justification
3. Add Customizable Access Request Forms
Allow System Admins to customize the request workflow with:
- Custom fields
- Dropdowns
- Approval routing
- Manager approval requirements
- Expiration/duration requests
This would significantly improve governance capabilities without requiring external workaround solutions.
Event Reporting / Audit Improvements
While Smartsheet Event Reporting currently captures many sharing and permission-related events, there are still important governance gaps for enterprise access reviews and auditing.
Specifically, administrators currently cannot reliably report on:
- The business justification/reason submitted when requesting access
- The actual individual who approved or granted the access request
Additional governance-focused metadata in Event Reporting would significantly improve auditability and access management transparency.
Requested enhancements:
- Include the user-submitted access request justification in Event Reporting
- Record the actual approver/grantor of access requests (not only the asset owner when applicable)
- Improve visibility into the end-to-end access approval workflow
These improvements would help organizations strengthen:
- Security auditing
- Compliance reporting
- SOX/internal controls
- Access certification reviews
- Incident investigations
- Enterprise governance processes
Currently, organizations often need to rely on email notifications or external workflows to retain this governance information, which limits centralized reporting and audit capabilities.
Business Impact
Many enterprise customers are building custom workflows outside of Smartsheet using:
- Forms
- Power Automate
- Bridge
- APIs
simply to compensate for limitations in the native access request process.
Providing stronger built-in governance controls would:
- Reduce administrative overhead
- Improve security posture
- Increase enterprise adoption
- Improve audit readiness
- Reduce dependency on external tooling
Why This Matters
As Smartsheet continues expanding enterprise capabilities, governance and auditability become increasingly critical.
Native access requests should support:
- least privilege access
- approval transparency
- enterprise compliance standards
- configurable governance policies
instead of relying on fixed, lightweight collaboration workflows.
This enhancement would make Event Reporting significantly more actionable and valuable for enterprise administrators.
Chizu Hieida
Re: Formula result is "N/A". Automation does not seem to evaluate it properly
Hey @Adrien Leduc thanks for that answer. The N/A result isn't an error, it's me indicating that a the contact in that column isn't needed for that row. It's a formula result like: IF(x=x, y, "N/A").
But regardless of the source of the text, it seems like the Automations can be weird about evaluating it. I decided to work around this by rewriting the formulas to return "" instead of "N/A". Automations seem to have no issue with conditions evaluated to is or is not blank.
Re: Get project hyperlink from metadata into other sheets
Yes it's a paid add-on or included in AWM pricing. Sorry, there might be a way to do it via API but it's not my jam.
Re: Get project hyperlink from metadata into other sheets
Hi @MockerTwin22, this is a known limitation with Smartsheet and Control Center. The only I found to automate that is with Bridge, do you have access?
Re: Get project hyperlink from metadata into other sheets
Getting it out into other sheets does need some other app whether that be the API, Bridge, or some other similar third party app such as Zapier or Power Automate.
If you want it on a dashboard though, while metrics widgets also do not preserve the hyperlink, reports do.
That being said… Bridge is adds a HUGE amount of power to any Smartsheet build. It is rare that the price can't be justified by the amount of automation and time saved. While there is a bit of a learning curve to it, most regular Smartsheet users are able to leverage it in a lot of ways that don't require getting on the schedule of your IT team or otherwise paying for a custom API integration.
Paul Newcome

