FAQ: How can I “Follow” a specific Topic?

Genevieve P.
Genevieve P. Employee Admin
edited 06/20/22 inWelcome to the Community

Recent Discussions feed:

You can follow specific topics by these steps:

  • Click onTopicsfrom the header menu.
  • From this page, find the Topic you’d like to follow and click it.
  • Find theBell Iconand select from the preference options.

Note: some Topics have sub-Topics. You may need to click another Topic to find the bell icon.

Screen Shot 2022-06-20 at 3.25.01 PM.png

You can set up yourNotification Preferencesto receive either email notifications or popups in the Community whenever a new post is made within a specific Topic.

Tags:

    Categories

    @Azure.Sessums<\/a> It should work to use JOIN(DISTINCT(COLLECT())) . <\/p>

    Here is the DISTINCT function, it returns the distinct values from a range.<\/p>

    https:\/\/help.smartsheet.com\/function\/distinct<\/a><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-26 08:13:48","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-09-26T12:28:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":95854,"type":"question","name":"How to use symbols with formula","excerpt":"=IF([\"Will Call\" Trips]@row < [\"Will Call\" Goal]@row, \"Yes\", \"No\") What do I use if I want the symbol to be Hold if the answer is zero?","categoryID":322,"dateInserted":"2022-09-23T16:27:32+00:00","dateUpdated":null,"dateLastComment":"2022-09-24T21:54:32+00:00","insertUserID":7176,"insertUser":{"userID":7176,"name":"Samuel Dowdy Jr.","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Dowdy%20Jr.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xCPC8T7_6Hw!zIfBc_qPyz4!RrIUl9SqFWX","dateLastActive":"2022-09-25T21:55:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-26T08:51:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":31,"score":null,"hot":3328008724,"url":"https:\/\/community.smartsheet.com\/discussion\/95854\/how-to-use-symbols-with-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95854\/how-to-use-symbols-with-formula","format":"Rich","lastPost":{"discussionID":95854,"commentID":344686,"name":"Re: How to use symbols with formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344686#Comment_344686","dateInserted":"2022-09-24T21:54:32+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-26T08:51:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-23T18:18:59+00:00","dateAnswered":"2022-09-23T16:34:10+00:00","acceptedAnswers":[{"commentID":344574,"body":"

    @Samuel Dowdy Jr.<\/a> <\/p>

    =IF([\"Will Call\" Trips]@row=0, \"Hold\", IF([\"Will Call\" Trips]@row < [\"Will Call\" Goal]@row, \"Yes\", \"No\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 18:18:59","updateUser":{"userID":7176,"name":"Samuel Dowdy Jr.","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Dowdy%20Jr.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xCPC8T7_6Hw!zIfBc_qPyz4!RrIUl9SqFWX","dateLastActive":"2022-09-25T21:55:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":95759,"type":"question","name":"is it possible to index a column from a different sheet if you dont have a value to match it with?","excerpt":"im trying to work around the 500 cell linking limit, which makes a lot of manual effort. i would appreciate any help.","categoryID":322,"dateInserted":"2022-09-22T01:32:37+00:00","dateUpdated":null,"dateLastComment":"2022-09-25T21:04:19+00:00","insertUserID":152694,"insertUser":{"userID":152694,"name":"artrubio","url":"https:\/\/community.smartsheet.com\/profile\/artrubio","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-25T17:39:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-26T08:51:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3327952016,"url":"https:\/\/community.smartsheet.com\/discussion\/95759\/is-it-possible-to-index-a-column-from-a-different-sheet-if-you-dont-have-a-value-to-match-it-with","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95759\/is-it-possible-to-index-a-column-from-a-different-sheet-if-you-dont-have-a-value-to-match-it-with","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":95759,"commentID":344700,"name":"Re: is it possible to index a column from a different sheet if you dont have a value to match it with?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344700#Comment_344700","dateInserted":"2022-09-25T21:04:19+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-09-26T08:51:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-26T08:14:19+00:00","dateAnswered":"2022-09-22T07:03:21+00:00","acceptedAnswers":[{"commentID":344384,"body":"

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

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

    Here's one way you can do it.<\/p>

    You could use cross-sheet formulas combined with either a VLOOKUP or INDEX\/MATCH<\/strong> structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.<\/p>

    To connect them row by row, you'd use an Autonumber Column in the Source sheet and add a so-called helper column to manually add the row id on as many rows as you think you need in the Destination sheet.<\/strong><\/p>

    Would that work\/help? <\/p>

    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","log":{"dateUpdated":"2022-09-26 08:14:19","updateUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/NDZ9JFCTQ8E3\/n8CCYP0Y12F8V.png","dateLastActive":"2022-09-26T12:28:36+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending Community Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">