Column Filters

Cameron Yule
Cameron Yule ✭✭
inSmartsheet Basics

Hello All

I run a residential construction company and have almost every aspect of the business running through Smartsheet.

This has led to the template for our 'standard home' now containing 105 columns!

The bulk of these are for calculations and automation, and are only required for specific processes when creating a new project.

I have created a instruction list for setting up a new job, and this requires having only certain columns showing, currently we are hiding the unused columns. The problem with this is you then have to 'unhide all columns' when you want to see one again, and then hide them all again.

Ideally, i would love a 'column filter' which would allow me to preset views for working in.

I know reports look like the answer, but they are limited to not allowing for a row to be added, and also the conditional formatting does not update immediately which makes them less visual to work in.


Anyone have any ideas/suggestions as to how i can work around this issue?

· Share on Facebook Share on Twitter

Answers

  • Frank Falco
    Frank Falco ✭✭✭✭✭✭
    edited 05/19/22

    Have you looked at Dynamic View?

    Smartsheet Dynamic View | Smartsheet

    Datasheet-Dynamic-Views-2018.pdf (smartsheet.com)


    ✅Did my post help answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    · Share on Facebook Share on Twitter
  • Cameron Yule
    Cameron Yule ✭✭

    下午好,谢谢你的回应


    I did watch a seminar yesterday for dynamic view, but it appeared to just be a glorified report. This also requires us to upgrade to the next plan level which is a big jump up in licensing costs.

    · Share on Facebook Share on Twitter
  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 05/19/22

    Hi@Cameron Yule

    I hope you're well and safe!

    伟大的idea! That would be a great addition to Smartsheet features.

    Please submit an Enhancement Request when you have a moment.


    To add to Frank's excellent advice/answer.

    Here's a possible workaround or workarounds

    • Split out the sheet into multiple sheets except for the information that has to be in the main sheet.


    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic week!

    Best,

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    ✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking it Insightful/Vote Up 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

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Cameron Yule
    Cameron Yule ✭✭

    Thank you Andree

    All the data is relevant to certain lines, and if you delete an item from a timeline (IE: bathroom does not have a bath).

    Deleting the bath will:

    Remove the bath from the merchant quote list

    Remove the bath details from the plumbing specification report

    Delete the cost of the bath from the projects expenses forcast.

    Delete the bath and all upgrade options from the app i have created

    Delete the bath from the fittings order form

    Delete the booking for both the plumber and builder to install the bath


    If i was to separate these items into sheets, i would need to keep hunting through the sheets to find the broken links, which would be time consuming and likely to be missed.


    For now , i will try highlighting the columns in colours so they are easier to identify at a glance

    · Share on Facebook Share on Twitter
  • Mike TV
    Mike TV ✭✭✭✭✭✭

    I have sheets that have a lot of hidden columns as well. I would LOVE LOVE LOVE the ability to search for a column and if it's hidden it becomes un-hidden when it's searched for and found. Such a PAIN trying to remember which columns to hide again after you un-hide them all.

    · Share on Facebook Share on Twitter

Categories

\n \n https:\/\/community.smartsheet.com\/discussion\/108880\/recover-a-row-that-was-accidentally-moved-then-deleted\n <\/a>\n<\/div>\n

Hey @GlennJo<\/a>,<\/p>

the sheet should be available in the owner of the sheet, deleted files. If it is specifically a row of data that was deleted, you can try checking the activity log to see if it shows the removed data there.<\/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":108822,"type":"question","name":"Activity Log | Rows Deleted Filter","excerpt":"I've got a conundrum on my hands where a record has gone missing. In the Activity Log, I'm able to find the record of when it was created. However, there is nothing I'm seeing indicating that it was deleted (even though the Activity Log doesn't have a specific filter for this, I traced through the log for the past 11 days…","snippet":"I've got a conundrum on my hands where a record has gone missing. In the Activity Log, I'm able to find the record of when it was created. However, there is nothing I'm seeing…","categoryID":321,"dateInserted":"2023-08-10T21:46:08+00:00","dateUpdated":null,"dateLastComment":"2023-08-10T22:01:16+00:00","insertUserID":121055,"insertUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-08-11T20:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":121055,"lastUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-08-11T20:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":36,"score":null,"hot":3383410044,"url":"https:\/\/community.smartsheet.com\/discussion\/108822\/activity-log-rows-deleted-filter","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108822\/activity-log-rows-deleted-filter","format":"Rich","tagIDs":[447],"lastPost":{"discussionID":108822,"commentID":390131,"name":"Re: Activity Log | Rows Deleted Filter","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390131#Comment_390131","dateInserted":"2023-08-10T22:01:16+00:00","insertUserID":121055,"insertUser":{"userID":121055,"name":"Jake Gustafson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Jake%20Gustafson","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-lnW91tuGTw!bO9UmyNQSXQ!WUYBUm0HF6t","dateLastActive":"2023-08-11T20:29:49+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SIFFD1TSN3Q6\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-10T22:01:20+00:00","dateAnswered":"2023-08-10T22:01:16+00:00","acceptedAnswers":[{"commentID":390131,"body":"

Ok, I found it. Classic case of submit something for help, then find the answer. I think what may have happened previously, is that I turned on all the filters, but since there isn't one for a Deleted Row, maybe the Deleted Row was hidden. When I came back, I didn't click anything on the filters for the Activity Log and when scrolling through looking for the 'magic' delete word, I found the record I was looking for.<\/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":447,"urlcode":"activity-log","name":"Activity Log"}]},{"discussionID":108801,"type":"question","name":"Adding users to our account if they are already licensed on another account","excerpt":"Hiya, Couldn't find an answer to my exact question, so hoping someone can help. I am working with an external client to my company, and need to add them to our account on paid licenses. 1) Can I add them to our account if they have a different email address to our company? 2) If they already have an existing licensed…","snippet":"Hiya, Couldn't find an answer to my exact question, so hoping someone can help. I am working with an external client to my company, and need to add them to our account on paid…","categoryID":321,"dateInserted":"2023-08-10T16:26:57+00:00","dateUpdated":null,"dateLastComment":"2023-08-10T17:22:07+00:00","insertUserID":128877,"insertUser":{"userID":128877,"name":"Holly Benjamin","url":"https:\/\/community.smartsheet.com\/profile\/Holly%20Benjamin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-10T17:23:19+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-08-11T20:31:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":29,"score":null,"hot":3383373544,"url":"https:\/\/community.smartsheet.com\/discussion\/108801\/adding-users-to-our-account-if-they-are-already-licensed-on-another-account","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108801\/adding-users-to-our-account-if-they-are-already-licensed-on-another-account","format":"Rich","tagIDs":[543],"lastPost":{"discussionID":108801,"commentID":390085,"name":"Re: Adding users to our account if they are already licensed on another account","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390085#Comment_390085","dateInserted":"2023-08-10T17:22:07+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-08-11T20:31:01+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-10T17:23:30+00:00","dateAnswered":"2023-08-10T17:22:07+00:00","acceptedAnswers":[{"commentID":390085,"body":"

They can be added if they use a different domain.<\/p>


<\/p>

If they are licensed on another account, they would need to either be first removed from that account (can cause some logistical headaches) or added as an unlicensed user on your account.<\/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":543,"urlcode":"licensed-users","name":"licensed users"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&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":4940,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Recover a Row that was accidentally moved then deleted

    I was attempting to copy a row from sheet 1 to sheet 2, but I accidentally moved the row then deleted it, but then realized belatedly that the original (now deleted) data in sheet 1 had been moved. Apparently one can not simply use the "undo action" arrow after moving something--the option is grayed out as in not…

  • Activity Log | Rows Deleted Filter

    I've got a conundrum on my hands where a record has gone missing. In the Activity Log, I'm able to find the record of when it was created. However, there is nothing I'm seeing indicating that it was deleted (even though the Activity Log doesn't have a specific filter for this, I traced through the log for the past 11 days…

  • Adding users to our account if they are already licensed on another account

    Hiya, Couldn't find an answer to my exact question, so hoping someone can help. I am working with an external client to my company, and need to add them to our account on paid licenses. 1) Can I add them to our account if they have a different email address to our company? 2) If they already have an existing licensed…

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

 Watch video