Feature request: Hashtags to create automatic reports

Susana
Susana ✭
edited 12/09/19 inSmartsheet Basics

Hello!

So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department.

We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according to stages and deadlines, individual task sheets for each member of staff, team Dashboards and individual dashboards.

So far we're pretty satisfied with the setup, but there are a couple of features missing, and the most important one for us is:the ability to create hashtags on sheets.

Our idea is that...

  • the hashtags would have the choice to be defined on a workspace level to avoid different ways of spelling the same work and/or the same project
  • The hashtags would be placed on sheet rows
  • the hashtags would be a link to an automatically created report consolidating all the rows in a certain workspace
  • The hashtag reports could be embedded on dashboards
  • When typing a hashtag on a sheet, the Smartsheet would automatically suggest existing hashtags (regex).

Any more contributions?

We currently work around it by having a Reference / ID column in all sheets, but with a high volume of rows, it's incredibly hard to police naming consistency, which makes work coordination incredibly hard.

Other team/project management providers offer this feature and we think it's very valuable.

Thanks!

Tags:
· Share on Facebook Share on Twitter

Comments

Categories

Hi @AllenWeston<\/a> <\/p>

I hope you're well and safe!<\/p>

There's a known issue at the moment.<\/p>

\n \n https:\/\/status.smartsheet.com\/incidents\/n3gv8nrd6cyf\n <\/a>\n<\/div>


<\/p>

\n \n https:\/\/status.smartsheet.com\/\n <\/a>\n<\/div>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":106259,"type":"question","name":"Calculate workdays, excluding weekends (Days elapsed)","excerpt":"I found the solution for \"How to calculate days a ticket is open\/closed\" on your site (solution submitted by Andrée Starå), but, I need the formula to count just the weekdays, excluding weekends. I tried a couple of different ways, but cannot get it to work properly. Any help would be greatly appreciated! This is the…","categoryID":321,"dateInserted":"2023-06-09T12:23:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T17:37:13+00:00","insertUserID":162244,"insertUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162244,"lastUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":95,"score":null,"hot":3372908458,"url":"https:\/\/community.smartsheet.com\/discussion\/106259\/calculate-workdays-excluding-weekends-days-elapsed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106259\/calculate-workdays-excluding-weekends-days-elapsed","format":"Rich","lastPost":{"discussionID":106259,"commentID":380147,"name":"Re: Calculate workdays, excluding weekends (Days elapsed)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380147#Comment_380147","dateInserted":"2023-06-12T17:37:13+00:00","insertUserID":162244,"insertUser":{"userID":162244,"name":"Seneca","title":"Technical Writer","url":"https:\/\/community.smartsheet.com\/profile\/Seneca","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/5100NMIIA7HJ\/n3UY7D9OQBBU6.jpg","dateLastActive":"2023-06-12T17:33:07+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\/Y6CX51TQRVBZ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-12T17:37:11+00:00","dateAnswered":"2023-06-12T17:19:34+00:00","acceptedAnswers":[{"commentID":380143,"body":"

Either of these should work. They just approach the logic from a different direction.<\/p>


<\/p>

=IF([Project Completion Date]@row <> \"//www.santa-greenland.com/community/discussion/28051/\", NETWORKDAYS([Project Start Date]@row, [Project Completion Date]@row), NETWORKDAYS([Project Start Date]@row, TODAY()))<\/p>


<\/p>

=IF([Project Completion Date]@row = \"//www.santa-greenland.com/community/discussion/28051/\", NETWORKDAYS([Project Start Date]@row, TODAY()), NETWORKDAYS([Project Start Date]@row, [Project Completion Date]@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":106251,"type":"question","name":"Unable to edit dashboard with Admin rights","excerpt":"Hello all, I have added a user as an admin for a dashboard but she is unable to see the edit (pencil) button. Tried adding her as admin in the workspace but still doesn't work. Any idea? We are on Enterprise plan. Thank you.","categoryID":321,"dateInserted":"2023-06-09T06:08:55+00:00","dateUpdated":"2023-06-09T07:54:11+00:00","dateLastComment":"2023-06-12T13:55:34+00:00","insertUserID":124399,"insertUser":{"userID":124399,"name":"firestorm","url":"https:\/\/community.smartsheet.com\/profile\/firestorm","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!0pnQ_1i5ezw!2uNXv2NG1jQ!_3DRw9ClXTT","dateLastActive":"2023-06-12T07:56:55+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-06-12T20:11:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":68,"score":null,"hot":3372875069,"url":"https:\/\/community.smartsheet.com\/discussion\/106251\/unable-to-edit-dashboard-with-admin-rights","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106251\/unable-to-edit-dashboard-with-admin-rights","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":106251,"commentID":380080,"name":"Re: Unable to edit dashboard with Admin rights","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380080#Comment_380080","dateInserted":"2023-06-12T13:55:34+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-06-12T20:11:23+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-12T08:23:14+00:00","dateAnswered":"2023-06-12T04:13:41+00:00","acceptedAnswers":[{"commentID":380023,"body":"

@firestorm<\/a> <\/p>

Yes, unfortunately, (if I'm not mistaken) a license is needed to be able to edit a Dashboard. <\/p>

The sheet Owner and Admins can add or edit dashboard widgets. A license is required.<\/em><\/p>

More info. <\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/518558-widget-types-for-smartsheet-dashboards\n <\/a>\n<\/div>


<\/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":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"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":5371,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Using Smartsheet