Best Of
Re: Sharing reports with data without even view access to the source sheet
@johngraham78 , if the user only has view access, then they can't view the hidden columns. IMO that's a good feature. I've provided view access to clients and hidden columns that I didn't want them to see. However, you need to be aware that if they download the sheet, the hidden columns will be downloaded and will be accessible.
Crown
Re: Sharing reports with data without even view access to the source sheet
I have a potential workaround for this problem (with drawbacks of course).
If you hide every column in the source sheet (you must keep one column visible though), those with view only access cannot unhide any columns and therefore cannot see any data.
This could be used in conjunction with a duplicate sheet from which reports are based. As some have mentioned, a series of automations and datamesh could keep the sheets in sync.
Dynamic view won't work for my particular situation, as I'm using reports with 'current user' dependencies to feed charts on a dashboard.
johngraham78
Re: Sharing reports with data without even view access to the source sheet
Except Dynamic View does not hold formatting of your report… ie grouping/summary
kera
Re: How to extract email address from a contact list the use the value in an adjacent column
I was able to do this but had to add an additional column to the sheet. I have the contact column, text contact column, then a third to extract the email address. I populate the contact in the first column, do a simple copy/paste into the second (text), and have a column formula for the 3rd that extracts the email only using this:
=SUBSTITUTE(MID([Text Contact]@row, FIND("<", [Text Contact]@row) + 1, LEN([Text Contact]@row) - (FIND("<", [Text Contact]@row) + 1)), ">", "")
kelly.huber
Ability to duplicate Pivot App sheets
Allow the ability to duplicate a pivot app sheet if all you are changing is some of the columns and rows, but are using the same data set and destination location.
Kevin7859
Re: Cell linking
Great news, glad to help. Please mark this as accepted so others can search for it in the future.
Cheers,
Hudson
Hudson_Miller
Update Request - ability to select "include Sheet Level attachments"
Please include the ability to include sheet level attachments to row update requests
PeggyLang
Metric Widget Font Size
It would be really great if we had a much wider range of font sizes available for metric widgets. Sometimes a metric really needs to make an impact, and the current size options are limited.
CyberJL
Re: Subfolders within Collections
After working with collections for some time, folders would be a significant quality of life change and be extremely beneficial.
sirhChris E
Re: Searching Cell History
These sound like workarounds to something that should be a general feature. I hope Smartsheet seriously considers adding this feature. Don't forget to add in it the suggestions on your Smartsheet home screen. https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409
JessicaD