Free Users and Reports
Our company has many free users as that is all they require with a limited number of licenced admins.
My issue is regarding the Reports. As an admin I can create and edit happily but my free users are suddenly unable to change the filters.
I've looked up free user access and Smartsheet specifically says they can still edit reports
However, my users are finding the filters tab greyed out so they cannot change
I have made sure that they have full rights on both the report sharing and also the underlying smartsheet involved.
So now I am stuck - am I missing something or have the permissions been revoked for free users as this could be a bit of a game changer for us.
Many thanks in anticipation of your help
kindest regards
Sue
Sue Rogers
AmerisourceBergen - MWI Animal Health
Business Analyst
Answers
-
Jason Duryea ✭✭✭✭✭✭
Here's the page outlining the permissions on sheets, reports or workspaces and where a user license is required.
As you can see below, modifying the Report Builder (i.e. Filters) requires a user license. I'm not sure if/when they may have changed this. As far as I remember, a license was required to perform these types of changes. Free-collaborator is generally limited to editing/viewing data in a report only.
-
SueinSpain ✭✭✭✭✭
谢谢你杰森,我认为你可能是对的,但安oying as says they can edit in the "What can free users do" page and they certainly could do this before. I'll raise a ticket with them to get clarity as conflicting information.
Many thanks
Sue
Sue Rogers
AmerisourceBergen - MWI Animal Health
Business Analyst
-
Genevieve P. Employee Admin
Filters in Reports are how the Report is configured, part of the "report builder criteria". This means that only Admins and Owners in the Report can adjust the filter, and yes, they would need to be licensed as well.
Cheers!
Genevieve
-
SueinSpain ✭✭✭✭✭
Thanks Genevieve
How silly as they didn't used to and the what free users can do guide says they are able to do this.
Conflicting information on this.
Sdaly looks like I won't be able to use reporting in our business as too few licenced users :(
Sue Rogers
AmerisourceBergen - MWI Animal Health
Business Analyst
-
Genevieve P. Employee Admin
Would you be able to send me the URL with the Free User information where it says they can adjust Report Builder criteria? I'll pass this along to the Help Article team so the content is updated to be accurate.
Thanks!
Categories
Hi @Jagdeep<\/a> - Unfortunately, my experience has been that Datamesh \"Immediate\" can take up to 5 minutes (perhaps more).<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":381,"urlcode":"DataMesh","name":"DataMesh"}]},{"discussionID":106941,"type":"question","name":"How to show data of previous working day?","excerpt":"For a stacked column chart on a dashboard, I count the number of applicable cases daily. The current formula shows NO DATA on Monday because TODAY(-1) is Sunday. =COUNTIFS({Customer Escalation Region}, $Region@row, {Customer Escalation Request Reason}, \"Close Gap\", {Customer Escalation Request Date}, TODAY(-1)) I'm…","snippet":"For a stacked column chart on a dashboard, I count the number of applicable cases daily. The current formula shows NO DATA on Monday because TODAY(-1) is Sunday.…","categoryID":321,"dateInserted":"2023-06-27T10:29:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-27T12:02:55+00:00","insertUserID":162184,"insertUser":{"userID":162184,"name":"Sachiko Kagami","title":"Customer Service Manager","url":"https:\/\/community.smartsheet.com\/profile\/Sachiko%20Kagami","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T12:25:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":151203,"lastUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T12:11:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3375730935,"url":"https:\/\/community.smartsheet.com\/discussion\/106941\/how-to-show-data-of-previous-working-day","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106941\/how-to-show-data-of-previous-working-day","format":"Rich","lastPost":{"discussionID":106941,"commentID":382502,"name":"Re: How to show data of previous working day?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382502#Comment_382502","dateInserted":"2023-06-27T12:02:55+00:00","insertUserID":151203,"insertUser":{"userID":151203,"name":"Nick Korna","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Korna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T12:11:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-27T11:47:48+00:00","dateAnswered":"2023-06-27T11:40:22+00:00","acceptedAnswers":[{"commentID":382497,"body":" Hi @Sachiko Kagami<\/a>,<\/p> The WORKDAY function is what you're after here.<\/p>