Options
Anthony DAmbrosio ✭✭✭✭
01/06/23 in Formulas and Functions
Hello Smartsheet Community,
I am building out a grid / sheet for our sales team and want to use the Current User View so that any time a report opens this sheet, they only see their customer information. That said, I build a filter within the grid / sheet that when Sales Rep, is on of, Current User it shows me just my customer information. When I open the sheet, it filters out all of the sales reps expect for me. When I sent a couple of other sales rep the link to this grid / sheet and they open it, they see everyone.
Now when I went to share the share with the other sales reps, I did update the default view to be my "Current User View" filter and that still did not work.
Does anyone know what I am doing wrong? It works when I create a report, but I want the sales reps to be able to update any fields necessary as things change with their customers.
Any help / suggestions would be greatly appreciated.
Anthony D'Ambrosio
0 · Share on FacebookShare on Twitter
- See AlsoUser Management | Smartsheet Learning CenterCreate a filter to show or hide dataSmartsheet Stock: Finally Showing The Capacity To Rally (NYSE:SMAR)How To View Users In Smartsheet
Paul Newcome ✭✭✭✭✭✭
01/06/23 Answer ✓
Options
Users should be able to update fields in a report as long as they have editor access to both the report and the underlying sheet(s).
As for the sheet filter... You will need to make sure that the filter has been shared (checkbox in the filter builder), and other users will need to apply the filter when they open the sheet.
1 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
01/06/23 Answer ✓
Options
Hi @Anthony DAmbrosio
I hope you're well and safe!
To add to Paul's excellent answer/advice.
To add an image to a cell through a Report, you'd select the Row Actions options and then Edit and then click on the Kebab menu on the cell and select Insert Image.
Would that work/help?
I hope that helps!
Have a fantastic weekend & Happy New Year!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
1 · Share on FacebookShare on Twitter
Answers
Paul Newcome ✭✭✭✭✭✭
01/06/23 Answer ✓
Options
Users should be able to update fields in a report as long as they have editor access to both the report and the underlying sheet(s).
As for the sheet filter... You will need to make sure that the filter has been shared (checkbox in the filter builder), and other users will need to apply the filter when they open the sheet.
1 · Share on FacebookShare on Twitter
Anthony DAmbrosio ✭✭✭✭
01/06/23
Options
@Paul Newcome
Thank you for your feedback on my question concerning current user view. One thing I did notice that you are not able to do on the report is add in images. For example, if a sales rep wants to upload an image of their contact in the report they are not aloud.
0 · Share on FacebookShare on Twitter
Andrée Starå ✭✭✭✭✭✭
01/06/23 Answer ✓
Options
Hi @Anthony DAmbrosio
I hope you're well and safe!
To add to Paul's excellent answer/advice.
To add an image to a cell through a Report, you'd select the Row Actions options and then Edit and then click on the Kebab menu on the cell and select Insert Image.
Would that work/help?
I hope that helps!
Have a fantastic weekend & Happy New Year!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
1 · Share on FacebookShare on Twitter
Help Article Resources
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("searchbox"+index); Coveo.initSearchbox( searchBoxRoot, "https://search.smartsheet.com/community/" ); }); $('#titleBar .CoveoSearchbox').hide(); $('.coveoSearchButton').on("click",function(){ $('#titleBar .CoveoSearchbox').toggle(); }); // ====== Front Page Search Box ====== $('#Form_search').remove(); var boxes = ["#search-0", "#search-1", "#search-2", "#search-3", "#search-4", "#search-5"]; console.log("PT: Before search box replacement"); $(boxes).each(function(i, val) { // ====== Front Page Search Box ====== $(val).each(function( index ) { console.log(this); $('#searchbox' + i).remove(); $(this).find('form').remove(); $(this).addClass('fpsearchbox'); $(this).attr('id', 'fpsearchbox' + index); $(this).append('
'); $(this).css('min-height', '20px'); const searchBoxRoot = document.getElementById("fpsearchbox"+index); var action = "https://search.smartsheet.com/community/"; if ( $('body').hasClass('Categories')) { var category=$('h1.heading-1').text(); if (category === "Smartsheet Product Feedback & Ideas") { category = encodeURIComponent(category); Coveo.$(searchBoxRoot).on('buildingQuery', function(e, args) { args.queryBuilder.advancedExpression.addFieldExpression('@communitycategory', '==', [category]); }); action = action + '#&f:@communitycategory=['+category+']'; } } Coveo.initSearchbox( searchBoxRoot, action ); }); }); });
Categories
- All Categories
- 14 Welcome to the Community
- 59.3K Get Help
- 88 Global Discussions
- 93 Industry Talk
- 399 Announcements
- 12 Community Corner Newsletter
- 71 Brandfolder
- 121 Just for fun
- 43 Community Job Board
- 22 Member Spotlight
- 1 SmartStories
- 253 Events
- 13 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
