Share Filter Box Disappeared

Ken Armstrong
Ken Armstrong ✭✭✭✭✭
inSmartsheet Basics

Had an interesting glitch today. My company has an enterprise plan so sharing filters happens all the time. Today for some odd reason on just one sheet the share filter box just didn't populate for the owner of me as an admin of the sheet. To troubleshoot we did a bunch of refreshes, check other sheets (No Issues) and since this was a new sheet we built some general use filters to try and see if we edit them if it would reappear. Nothing changed! Next I made a copy of the Sheet via save as new and boom the share filter box reappeared. Did a refresh on the original and still gone. So now we are using the Copy I made and had to adjust the shuttles tied to the original.

Such an odd random glitch!

Ken Armstrong

Sr System Analyst, Carelon Medical Benefits Management

Certified Smartsheet Administrator

Be Firm! Be Fair! Be Friendly! Be Honest!!!

· Share on Facebook Share on Twitter

Best Answers

Answers

  • Kleerfyre
    Kleerfyre ✭✭✭✭✭✭

    Yeah, that is odd. I have never had this issue. Seems like really the only thing that could have been done was to recreate the sheet. Did you try looking at the Activity Logs to see if something appeared there that could point to why this error occurred?

    Jonathan Sanders, CSM

    "Change is always scary because it is unknown, but facing the unknown is what makes us stronger."

    · Share on Facebook Share on Twitter
  • Ken Armstrong
    Ken Armstrong ✭✭✭✭✭

    @KleerfyreYes I looked at the activity log and found nothing. Super odd. Thanks for the response!

    Ken Armstrong

    Sr System Analyst, Carelon Medical Benefits Management

    Certified Smartsheet Administrator

    Be Firm! Be Fair! Be Friendly! Be Honest!!!

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin
    edited 05/18/23

    Hi@Ken Armstrong

    Sharing filters is available on Business and Enterprise plans; is it possible that the owner of the sheet is on a Pro plan or other type of plan? Then when you created a copy, you became the owner on your Enterprise plan? (Here's more information).

    If the previous owner is on a Business or Enterprise plan, my next troubleshooting steps would be toosee if there's a browser extensionthat may be affecting the filter functionality.

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter
  • Ken Armstrong
    Ken Armstrong ✭✭✭✭✭

    Hey@Genevieve P.We are both on the same enterprise plan and use chrome with the same extensions that are up to date. It was just a one time thing so far and haven't run into it again. Once we made the copy of the sheet it was good on the copy.

    Ken Armstrong

    Sr System Analyst, Carelon Medical Benefits Management

    Certified Smartsheet Administrator

    Be Firm! Be Fair! Be Friendly! Be Honest!!!

    · Share on Facebook Share on Twitter
  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hey@Ken Armstrong

    I'm glad to hear it's sorted on the new sheet, but that's definitely unexpected for your first version! If it happens again, please do reach out to Support with a screen recording and the affected sheet URL.

    Cheers,

    Genevieve

    · Share on Facebook Share on Twitter
  • Ken Armstrong
    Ken Armstrong ✭✭✭✭✭
    Answer ✓

    @Genevieve P.I sure will!

    Ken Armstrong

    Sr System Analyst, Carelon Medical Benefits Management

    Certified Smartsheet Administrator

    Be Firm! Be Fair! Be Friendly! Be Honest!!!

    · Share on Facebook Share on Twitter

Categories

In that case (assuming {Range 1} is the QTR column), you would add it as another range\/criteria set within the COLLECT function.<\/p>

=JOIN(COLLECT({EORMF - Control Range 1}, {EORMF - Control Range 1}, @cell = \"Q1\", <\/strong>{Client Name}, [Client Name]@row), \" \")<\/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":[]},{"discussionID":107174,"type":"question","name":"Calendar view in Dashboard","excerpt":"We have a sheet that acts as our project calendar and use start\/end date columns to show them in calendar view across multiple days (to show duration). How can I get this same view of this sheet (or the report from sheet) in a dashboard. The report widget only appears to generate a gant view.","snippet":"We have a sheet that acts as our project calendar and use start\/end date columns to show them in calendar view across multiple days (to show duration). How can I get this same…","categoryID":321,"dateInserted":"2023-07-03T14:06:41+00:00","dateUpdated":null,"dateLastComment":"2023-07-03T17:04:50+00:00","insertUserID":163057,"insertUser":{"userID":163057,"name":"alisoncholak","url":"https:\/\/community.smartsheet.com\/profile\/alisoncholak","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bCP1Gy0kSHM!Dz-yg3sWw_0!KaCecJdROAp","dateLastActive":"2023-07-03T19:36:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-03T20:15:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3376797691,"url":"https:\/\/community.smartsheet.com\/discussion\/107174\/calendar-view-in-dashboard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107174\/calendar-view-in-dashboard","format":"Rich","tagIDs":[241,292],"lastPost":{"discussionID":107174,"commentID":383549,"name":"Re: Calendar view in Dashboard","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383549#Comment_383549","dateInserted":"2023-07-03T17:04:50+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-03T20:15:02+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-07-03T19:36:05+00:00","dateAnswered":"2023-07-03T17:04:50+00:00","acceptedAnswers":[{"commentID":383549,"body":"

You could publish the sheet as either Read Only - Full or Edit By Anyone and set the default view to calendar view. Then you would use the publish URL in a Web Content Widget.<\/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":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":107147,"type":"question","name":"Using IFERROR Formula - Still getting UNPARSEABLE error","excerpt":"I'm calculating a Burn Rate Percentage so it's using a basic calculation FORMULA =[Column4]@row \/ [Column2]@row --> This works fine However when one of the Column is a ZERO, I get a #DIVDE BY ZERRO error displayed. To address this error, I used an IFERROR but it's giving me an \"UNPARSEABLE\" error. I want the cell to…","snippet":"I'm calculating a Burn Rate Percentage so it's using a basic calculation FORMULA =[Column4]@row \/ [Column2]@row --> This works fine However when one of the Column is a ZERO, I get…","categoryID":343,"dateInserted":"2023-06-30T16:32:54+00:00","dateUpdated":"2023-06-30T16:35:50+00:00","dateLastComment":"2023-06-30T18:58:03+00:00","insertUserID":161931,"insertUser":{"userID":161931,"name":"Christine Cao","title":"Engagement Manager","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Cao","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-01T00:40:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-03T20:15:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":35,"score":null,"hot":3376296057,"url":"https:\/\/community.smartsheet.com\/discussion\/107147\/using-iferror-formula-still-getting-unparseable-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107147\/using-iferror-formula-still-getting-unparseable-error","format":"Rich","lastPost":{"discussionID":107147,"commentID":383396,"name":"Re: Using IFERROR Formula - Still getting UNPARSEABLE error","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383396#Comment_383396","dateInserted":"2023-06-30T18:58:03+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-03T20:15:02+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T18:53:59+00:00","dateAnswered":"2023-06-30T18:25:40+00:00","acceptedAnswers":[{"commentID":383387,"body":"

You need to remove the closing parenthesis from before the comma.<\/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":[]},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&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":5437,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Using Smartsheet

  • Can IF and the JOIN(COLLECT) formula be used together?

    Hello, I have a sheet with data. The data is populated from 4 forms and therefore populates in rows. The data needs to then be collated on one Smartsheet, and I am looking to pull through all the quarters into one cell where the quarter is "Q1". I have successfully pulled through all the "Q1" to show in a cell, by using…

  • Calendar view in Dashboard

    We have a sheet that acts as our project calendar and use start/end date columns to show them in calendar view across multiple days (to show duration). How can I get this same view of this sheet (or the report from sheet) in a dashboard. The report widget only appears to generate a gant view.

  • Using IFERROR Formula - Still getting UNPARSEABLE error

    I'm calculating a Burn Rate Percentage so it's using a basic calculation FORMULA =[Column4]@row / [Column2]@row --> This works fine However when one of the Column is a ZERO, I get a #DIVDE BY ZERRO error displayed. To address this error, I used an IFERROR but it's giving me an "UNPARSEABLE" error. I want the cell to…