functionality

Discussion List

=0 and <=1, \"On track\" =IF([%Complete)]1=1,\"Completed\" =IF([%Complete)]1<=1 and Due Date is past,…","categoryID":322,"dateInserted":"2016-06-08T09:36:11+00:00","dateUpdated":"2019-12-15T02:24:40+00:00","dateLastComment":"2019-12-15T02:31:01+00:00","insertUserID":6952,"insertUser":{"userID":6952,"name":"Brandon Schwartz","url":"https:\/\/community.smartsheet.com\/profile\/Brandon%20Schwartz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-06-08T09:20:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":6388,"lastUserID":6388,"lastUser":{"userID":6388,"name":"Gwyneth C","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gwyneth%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/76\/d9\/n76d9186b3bda2b96a96e61f72e8c9a49.jpg","dateLastActive":"2022-05-19T16:40:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":4083,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5176\/nested-if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5176\/nested-if-formula","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":64748,"type":"discussion","name":"[UPDATED] Community email notifications and saving important posts","excerpt":"Unsubscribe or Manage Community Email Notifications In the upper-right corner of the Community, click your Profile > Account & Privacy Settings Choose Notification Preferences from the options on the right. You can subscribe to any of your Followed Topics to receive notifications for every new post in the online Community!…","categoryID":328,"dateInserted":"2019-12-11T19:40:46+00:00","dateUpdated":"2023-06-01T13:08:56+00:00","dateLastComment":"2019-12-11T19:40:46+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-16T17:50:53+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-16T17:50:53+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":0,"countViews":833,"score":1,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/64748\/updated-community-email-notifications-and-saving-important-posts","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64748\/updated-community-email-notifications-and-saving-important-posts","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/0N086Y0FF9MO\/account.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Account.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":328,"name":"Welcome to the Community","url":"https:\/\/community.smartsheet.com\/categories\/welcome-to-the-community","allowedDiscussionTypes":[]},"tags":[{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":322,"urlcode":"FAQ","name":"FAQ"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"}],"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}]},{"discussionID":6382,"type":"discussion","name":"Archived Community Post: Why am I asked to log in to Smartsheet to use Community?","excerpt":"Hello, I am wondering why I am asked to log into Smartsheet if I have clicked on Help from my Smartsheet window? Shouldn't Smartsheet know I am logged in since I accessed it from my already logged into Smartsheet? Thanks!","categoryID":318,"dateInserted":"2016-10-26T10:10:54+00:00","dateUpdated":"2020-02-07T21:39:06+00:00","dateLastComment":"2019-09-24T10:18:44+00:00","insertUserID":3218,"insertUser":{"userID":3218,"name":"Cheryl Camacho","url":"https:\/\/community.smartsheet.com\/profile\/Cheryl%20Camacho","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/d3\/30\/nd3309a29a98c7eb8484e296b2858123c.jpg","dateLastActive":"2021-05-03T20:15:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":6388,"lastUserID":43126,"lastUser":{"userID":43126,"name":"gregjohnsondsm43126","url":"https:\/\/community.smartsheet.com\/profile\/gregjohnsondsm43126","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-03-14T22:27:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":44469,"score":1,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/6382\/archived-community-post-why-am-i-asked-to-log-in-to-smartsheet-to-use-community","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6382\/archived-community-post-why-am-i-asked-to-log-in-to-smartsheet-to-use-community","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">