How to get filters in Workapp page settings?

Kimbh
Kimbh ✭✭✭
inAdd Ons and Integrations

Hi, I want to filter a workapp to only show filters rows to a viewer. How do I get filters to show up in this section? I have put filters in the source sheet and the sheet view in workapp but nothing show in the filter section. Thanks you

WorkApp 10 25 2023.png


Tags:
· Share on Facebook Share on Twitter

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hey@Kimbh

    In order to get a Filter to show in your Workapp settings, it would need to be asharedfilter in the source sheet, with the "Share filter" box checked:

    Screenshot 2023-10-27 at 15.00.13.png

    Let me know if that resolved your problem!

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter

Answers

Categories

Support just let me know that this issue was resolved!!!<\/p>

I tested this with Source as Box and as Excel attachments and blank values now update!!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":112131,"type":"question","name":"How to get filters in Workapp page settings?","excerpt":"Hi, I want to filter a workapp to only show filters rows to a viewer. How do I get filters to show up in this section? I have put filters in the source sheet and the sheet view in workapp but nothing show in the filter section. Thanks you","snippet":"Hi, I want to filter a workapp to only show filters rows to a viewer. How do I get filters to show up in this section? I have put filters in the source sheet and the sheet view in…","categoryID":343,"dateInserted":"2023-10-25T14:52:14+00:00","dateUpdated":null,"dateLastComment":"2023-10-27T16:15:04+00:00","insertUserID":144572,"insertUser":{"userID":144572,"name":"Kimbh","url":"https:\/\/community.smartsheet.com\/profile\/Kimbh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T19:01:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":144572,"lastUser":{"userID":144572,"name":"Kimbh","url":"https:\/\/community.smartsheet.com\/profile\/Kimbh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T19:01:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3396670038,"url":"https:\/\/community.smartsheet.com\/discussion\/112131\/how-to-get-filters-in-workapp-page-settings","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112131\/how-to-get-filters-in-workapp-page-settings","format":"Rich","tagIDs":[371],"lastPost":{"discussionID":112131,"commentID":402041,"name":"Re: How to get filters in Workapp page settings?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402041#Comment_402041","dateInserted":"2023-10-27T16:15:04+00:00","insertUserID":144572,"insertUser":{"userID":144572,"name":"Kimbh","url":"https:\/\/community.smartsheet.com\/profile\/Kimbh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-27T19:01:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/EUVA1SS8M0SA\/workapp-10-25-2023.png"},"alt":"WorkApp 10 25 2023.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-27T16:19:48+00:00","dateAnswered":"2023-10-27T14:00:51+00:00","acceptedAnswers":[{"commentID":402014,"body":"

Hey @Kimbh<\/a> <\/p>

In order to get a Filter to show in your Workapp settings, it would need to be a shared<\/strong> filter in the source sheet, with the \"Share filter\" box checked:<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

Let me know if that resolved your problem!<\/p>

Cheers,<\/p>

Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":371,"urlcode":"workapps","name":"WorkApps"}]},{"discussionID":112176,"type":"question","name":"Very Small Sheet causes \"Error! Failed to issue the request,","excerpt":"I use Datamesh to update from one sheet to another and then back again. Been successful with these two sheets for a year. Suddenly I'm getting the errors: Error! Failed to issue the request, please relogin and try again. Error code: 0 - Error message:error This only happens one direction. I can datamesh from Sheet A to…","snippet":"I use Datamesh to update from one sheet to another and then back again. Been successful with these two sheets for a year. Suddenly I'm getting the errors: Error! Failed to issue…","categoryID":343,"dateInserted":"2023-10-25T22:34:58+00:00","dateUpdated":null,"dateLastComment":"2023-10-26T23:17:42+00:00","insertUserID":137486,"insertUser":{"userID":137486,"name":"Jack Swaton","url":"https:\/\/community.smartsheet.com\/profile\/Jack%20Swaton","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pLNVKZdwrDo!iVjUIgyE8TY!VkziYQqavjR","dateLastActive":"2023-10-27T16:43:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-10-28T13:20:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":35,"score":null,"hot":3396637960,"url":"https:\/\/community.smartsheet.com\/discussion\/112176\/very-small-sheet-causes-error-failed-to-issue-the-request","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112176\/very-small-sheet-causes-error-failed-to-issue-the-request","format":"Rich","tagIDs":[381],"lastPost":{"discussionID":112176,"commentID":401948,"name":"Re: Very Small Sheet causes \"Error! Failed to issue the request,","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401948#Comment_401948","dateInserted":"2023-10-26T23:17:42+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-10-28T13:20:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-26T22:25:03+00:00","dateAnswered":"2023-10-26T22:24:34+00:00","acceptedAnswers":[{"commentID":401942,"body":"

SOLVED!!!<\/p>

I wanted to use my target sheet with Resource Management so I turned DEPENDENCIES on in the PROJECT SETTINGS. <\/p>

My DataMesh was trying to update the START and END dates (which now were driven automatically in the target sheet) from the source sheet so Smartsheet could not update cells which were automatically updated.<\/p>

Once I turned DEPENDENCIES off in the target sheet my DataMesh worked just fine.<\/p>

:)<\/p>

Jack<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"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":381,"urlcode":"datamesh","name":"DataMesh"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=343&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-dateLastComment&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":715,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts

  • Data Shuttle not updating blank values from source file?

    Anyone else having this issue? All the Data Shuttles that I set up, are not anymore been bringing data to Smartsheet from cells that have changed to being blank in my Source Location. This was discovered yesterday, 10/17, when I received many reports from colleagues that work on different sheets that the data shuttle…

  • How to get filters in Workapp page settings?

    Hi, I want to filter a workapp to only show filters rows to a viewer. How do I get filters to show up in this section? I have put filters in the source sheet and the sheet view in workapp but nothing show in the filter section. Thanks you

  • Very Small Sheet causes "Error! Failed to issue the request,

    I use Datamesh to update from one sheet to another and then back again. Been successful with these two sheets for a year. Suddenly I'm getting the errors: Error! Failed to issue the request, please relogin and try again. Error code: 0 - Error message:error This only happens one direction. I can datamesh from Sheet A to…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video