Enhancement Request: Hide formulas from Viewers in Reports

A Viewer has little reason to need to see a formula in a column that is being displayed to them in a Report.

Please remove the hover for the Formula (the other hover that displays the full contents (display value) of the cell is OK, just hide the formulas.

Or tell me why this is a good feature.

Find more posts tagged with

Formulas

Reports

Security

Enhancement Request

Comments

Mike Wilday

I agree with this in part. If an admin is viewing a report, having the ability to hover would be a great option for troubleshooting a report, but if a user does not have editing privileges then it would be good to not have the formula appear.

Brad Jones

I third the motion.

sas-ss

+1. I have a report where the first column is an ID generated by a formula. Whenever the report is opened, the first cell in the first column is selected, and the formula displays. It's incredibly annoying and my report viewers should not be seeing that formula when they open the report.

Jinn Luu

+1.

Clients are getting annoyed by formulas appearing when they click on a cell with formulas.

Olli Matikainen

I agree... added a product enhancement request - would like to have an option to turn off/on formula display.

David Just

This is quite distracting when we try to go over external facing reports.

davidlord

+1. I agree. The display of the formula constantly impedes. It is very annoying. I would like to see an option to suppress the formula displaying when hovering.

Sign in to join the conversation!

Quick Links

Trending discussions

Join distinct collect with contains
Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns. Here is my attempt to use has - Heres the references (other sheet) Month, all Leads, and R&B prog is the first one (project)
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
Submitting forms for approval
Any help would be greatly appreciated! We have a 3-step process for travel approvals. I am able to get the forms to the correct people. I now have a request for the ability to add comments during the approval process. Staff submit request via Smartsheet form Automation forwards the form to the manager for approval Once…