My Smartsheet Wishlist

13

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    edited 10/28/19

    Hi Lachlan & Megan,

    Something like this is in the works.yes

    I can't wait!

    I hope that helps!

    有一个很好的一天!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    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.

  • Ezra
    Ezra ✭✭✭

    one that I just sent as a request...

    Due to the volume of projects and sheets and reports, I thought I'd try to count how many sheet links were broken/missing but it was a crazy attempt - just too many.

    It would be nice to have a clean-up option for "unknown sheet" links. Perhaps in the file properties dialog?

    PurgeUnknown01.png

    PurgeUnknown02.png

  • Love this idea Megan. We're considering it.

  • Thank you for the additional context Ella. I was thinking about this in the context of automated workflows, but I think this is probably best solved in other ways. I'll make sure this feedback is seen by the right team.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    This right here would be amazing!!

    thinkspi.com

  • Ezra
    Ezra ✭✭✭

    A summary from reports is what the Pivot add-on does/can do/is supposed to do... it's clunky and a bit limited, but shows promise for improvement.

  • @CollabMeganPMP
    @CollabMeganPMP ✭✭✭✭

    Ability@mentionin aDynamic View. That way I can interactively collaborate with people that don't have access to the entire sheet, but have access to the rows (would be great to be cards) in theDynamic View.

    Maybe restrict@mentionuse to those that are given permission to theDynamic View? I can't share the whole sheet with these folks, but if I could get them to interact with the data that they are allowed to see it would break down some barriers to collaboration.

    Better yet,be able to give row level security on a sheet.DREAM:by default it's turned off, but can be enabled and access on per-row level (or a set of rows selected by a filter) can be granted to an individual or a group to use ALL features of asheetand not restricted by the limitations of Dynamic View. Not to say that Dynamic View isn't deserving of some merit as I can see the use for both.

  • Kirstine
    Kirstine ✭✭✭✭✭✭

    Yaaaaas!!! This would be so helpful. For me it's when something's been marked as Invoiced as I archive by invoice date!

  • Kirstine
    Kirstine ✭✭✭✭✭✭

    I think one of my favourites (although there aren't any I DON'T love) is theProduct Enhancement Visibility and Upvoteone.

    We're all busy people and personally, when I see that people have already voiced their desire for an enhancement, I certainly don't really want to spend time I don't have creating a duplicate enhancement request... especially because at that point I usually have to set my mind to creating a workaround!

    I would like the ability to turn a discussion/comment directly into an enhancement request, ideally with the click of a button. I'd also like it to appear in the comments that the enhancement request has been created, and then have another button, again, in the comments of the original discussion, for the upvote.

  • Ella
    Ella ✭✭✭

    Hi Scott, thank you!

    As far as the Copy Row automated workflow, is this new feature coming prior to year end or sometime next year?

    Thanks

  • 谢谢这个线程,听到ab很有帮助out painpoints and use cases.

    There are a few I am particularly interested in and would like to give you updates or ask further questions outside of Community, if you could please send me an email directly -[email protected]

    1. Product Enhancement Visibility and Upvote

    2. Card View in Reports

    3. Ability to freeze rows/merge cells

    4. History of sent PDF's of reports.

    5.@Paul- let me know what you are thinking about "@character"

    6. Copying/pasting or duplicating columns -@Ella, would love to communicate about this as soon possible

    7. Anything Date/Time related

    8. Field next to that status that auto populates the date that the Resolved status was selected.

    9. Update/send row column "sets"



    10. Keep hidden columns hidden on edit row/print

    11. Checklists

    12.@Signature_Rachel- auto-size rows -would love to communicate about this as soon possible

    Summary reports - we do have the option for reports that can be built from the summary fields:https://help.smartsheet.com/learning-track/smartsheet-intermediate/sheet-summary-reports

    Or, are you wanting to see the actual summary field section in a report?

    Resource allocation -//www.santa-greenland.com/platform/10000ft

    Fill out the form if you'd like a demo or to speak with someone about these capabilities

    And - what I love about feedback our Smartsheet customers is that they are always teaching me something new:)

    @Paul- shift+click to resize multiple columns is a new one to me even after all these years. MANY THANKS!!!

    Here is one for you - to quickly copy a formula down (or up) a column on a large sheet:

    Select the cell with the formula you want to copy, then select ctrl+shift+down arrow keys (or up arrow) to select all cells beneath (or above), then select ctrl+d to copy the formula. (This is for Windows - I am not 100% positive of the corresponding keys to use on a Mac).

    Thank you everyone and thanks for bringing this thread to my attention, Scott W!

    Kara

  • @CollabMeganPMP
    @CollabMeganPMP ✭✭✭✭

    Thanks Kara!! I just sent you a note to the email address you listed in your reply. Look forward to speaking with you.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @kara,

    I have been trying to pull together some more coherent notes on the@characteridea. I will definitely reach out once I am able to put something together that makes sense.

    .

    As far as Shift+Click to select multiple columns for resizing all at once... Ctrl+Click also works so that you can match column size even if they aren't next to each other.

    .

    I haven't used the Ctrl+Shift+Arrow much just because of how far it jumps. It makes me nervous, and I end up backing up just to make sure. Haha.

    But in addition to that, Shift+PageUp or PageDown also work if you don't need to jump all the way to the bottom or top of a sheet.

    thinkspi.com

  • Ella
    Ella ✭✭✭
    edited 11/14/19

    Hi Kara,

    Thank You for considering our suggestions! I will send you an e-mail about copying/duplicating columns very soon.

    I do have another improvement I would like to see happen - in Alerts when selecting the columns to be included in the Alert body under Column Visibility Advanced Option, would you consider adding an option to Select All columns? I believe if we don't click on Display only these columns, everything gets sent in the alert, please let me know if this is correct.

    However for example if we need to exclude 2 columns only, we need to manually click to select every column besides these 2 whereas with Select All option, we can just deselect these 2 columns.

    Thanks

    PS. I submitted an enhancement request for this. :-)

  • Ella
    Ella ✭✭✭

    This is a great idea!

Apply a filter to the sheet and then you can select that filter in the Dynamic View.<\/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":106269,"type":"question","name":"Organizing Smartsheets into folders - Impact to DVs and WorkApps","excerpt":"Hello, I'm trying to organize the workspace listing in Smartsheet. If I create folders and move sheets into different folders, will that mess anything up for the Dynamic Views and WorkApp? Thanks, Frank","categoryID":321,"dateInserted":"2023-06-09T14:20:40+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T15:35:26+00:00","insertUserID":158554,"insertUser":{"userID":158554,"name":"Frank B.","url":"https:\/\/community.smartsheet.com\/profile\/Frank%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3HVYSSRAF5R9\/n9CDGKLAHBDUI.png","dateLastActive":"2023-06-09T15:34:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-11T03:56:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":27,"score":null,"hot":3372645966,"url":"https:\/\/community.smartsheet.com\/discussion\/106269\/organizing-smartsheets-into-folders-impact-to-dvs-and-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106269\/organizing-smartsheets-into-folders-impact-to-dvs-and-workapps","format":"Rich","tagIDs":[371,443],"lastPost":{"discussionID":106269,"commentID":379859,"name":"Re: Organizing Smartsheets into folders - Impact to DVs and WorkApps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379859#Comment_379859","dateInserted":"2023-06-09T15:35:26+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-11T03:56:44+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-09T15:36:14+00:00","dateAnswered":"2023-06-09T15:35:26+00:00","acceptedAnswers":[{"commentID":379859,"body":"

@Frank B.<\/a> If the folders are in the same Workspace that the sheets currently reside, there will for sure be no impact.<\/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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":106272,"type":"question","name":"Automation to send past due notifications to members","excerpt":"Hi All! I hope someone can help me create a (functioning!) automation. I need Smarsheets to send a daily notification to task owners, if the task is marked past due. Currently, I have been able to create an automation that will alert owners when a task becomes past due; however, this is a one-time notification. I've…","categoryID":321,"dateInserted":"2023-06-09T14:40:21+00:00","dateUpdated":"2023-06-09T14:48:10+00:00","dateLastComment":"2023-06-09T15:01:14+00:00","insertUserID":162249,"insertUser":{"userID":162249,"name":"blake_smith_b","title":"Accountant - Financial Reporting","url":"https:\/\/community.smartsheet.com\/profile\/blake_smith_b","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T15:10:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":142964,"lastUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":null,"hot":3372645095,"url":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106272\/automation-to-send-past-due-notifications-to-members","format":"Rich","tagIDs":[334,510],"lastPost":{"discussionID":106272,"commentID":379850,"name":"Re: Automation to send past due notifications to members","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379850#Comment_379850","dateInserted":"2023-06-09T15:01:14+00:00","insertUserID":142964,"insertUser":{"userID":142964,"name":"Ray Lindstrom","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Lindstrom","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5Y0KP6UKIBTU\/nY3615V0DPRZV.jpg","dateLastActive":"2023-06-09T16:08:12+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XJX8FMEG7M9C\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T15:12:48+00:00","dateAnswered":"2023-06-09T15:01:14+00:00","acceptedAnswers":[{"commentID":379850,"body":"

In the Trigger section, select \"When a date is reached\",<\/p>

Then select \"Custom\" for when to run the automation, and select \"Repeat Every\" and choose 1 Day.<\/p>

Then select your Conditions. For yours, you can say \"Where Past Due?\", and select \"is one of\", then choose \"Past Due\"<\/p>

Example below.<\/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":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":334,"urlcode":"automations","name":"Automations"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Using Smartsheet