Welcome to the Community

Welcome to our Smartsheet community! Here are a few tips to get you started.

Discussion List

Edit Profile. From the options on the right, click Notification Preferences. You can subscribe to any of your Followed Categories to receive notifications for every new post in the online Community.","categoryID":328,"dateInserted":"2019-12-11T19:40:46+00:00","dateUpdated":"2022-06-20T14:05:40+00:00","dateLastComment":"2019-12-11T19:40:46+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":539,"score":1,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/64748\/faq-how-do-i-unsubscribe-from-or-manage-the-email-notifications-i-receive","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64748\/faq-how-do-i-unsubscribe-from-or-manage-the-email-notifications-i-receive","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/92FA77JKZLXQ\/edit-profile.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Edit Profile.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":64747,"type":"discussion","name":"FAQ: Smartsheet Online Community error message: “Permission or Domain Denied”","excerpt":"If you receive the “Permission or Domain Denied,” error when you attempt to log in (or create a Community account for the first time), there are two possible reasons: The email address associated with the account has been warned and then blocked based on previously activity that was in violation of the Community…","categoryID":328,"dateInserted":"2019-12-11T19:37:17+00:00","dateUpdated":"2020-10-04T08:38:54+00:00","dateLastComment":"2019-12-11T19:37:17+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":259,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/64747\/faq-smartsheet-online-community-error-message-permission-or-domain-denied","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64747\/faq-smartsheet-online-community-error-message-permission-or-domain-denied","format":"Rich","groupID":null,"statusID":0,"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":322,"urlcode":"FAQ","name":"FAQ"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":332,"urlcode":"domain","name":"domain"}],"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":64746,"type":"discussion","name":"FAQ: How do I create a hyperlink in Community content?","excerpt":"To create a hyperlink, select the text you want to use for the link, and then click the link icon, in the far right of the formatting tools. After typing or pasting in the URL, press Enter to finalize the link. Make sure all hyperlinks created do not have any formatting applied (such as bold or italics). When a hyperlink…","categoryID":328,"dateInserted":"2019-12-11T19:34:49+00:00","dateUpdated":"2021-03-17T22:34:22+00:00","dateLastComment":"2019-12-11T19:34:49+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":124375,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":103,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/64746\/faq-how-do-i-create-a-hyperlink-in-community-content","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64746\/faq-how-do-i-create-a-hyperlink-in-community-content","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/194\/O9N5AS3K5BAZ.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Hyperlink_Markup.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":322,"urlcode":"FAQ","name":"FAQ"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":331,"urlcode":"hyperlink","name":"hyperlink"}],"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":64744,"type":"discussion","name":"FAQ: Bookmark posts in the Community","excerpt":"How do I save or bookmark a post to return to it later? Clicking on the Bookmark icon in the top-right corner of a post will bookmark the post. You can find all of your bookmarked posts under the My Bookmarks quick link: TIP: You can set up Notifications on your Bookmarked posts from your Profile.","categoryID":328,"dateInserted":"2019-12-11T19:28:06+00:00","dateUpdated":"2022-06-20T14:03:03+00:00","dateLastComment":"2019-12-11T19:28:06+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":248,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/64744\/faq-bookmark-posts-in-the-community","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64744\/faq-bookmark-posts-in-the-community","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SDA1I6Y54RSD\/bookmarks.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Bookmarks.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":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":64743,"type":"discussion","name":"FAQ: How can I “Follow” a specific Topic?","excerpt":"Recent Discussions feed: You can follow specific topics by these steps: Click on Topics from the header menu. From this page, find the Topic you’d like to follow and click it. Find the Bell Icon and select from the preference options. Note: some Topics have sub-Topics. You may need to click another Topic to find the bell…","categoryID":328,"dateInserted":"2019-12-11T19:19:52+00:00","dateUpdated":"2022-06-20T14:27:21+00:00","dateLastComment":"2019-12-11T19:19:52+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":137,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/64743\/faq-how-can-i-follow-a-specific-topic","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64743\/faq-how-can-i-follow-a-specific-topic","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/C7RCMPFW9E4D\/screen-shot-2022-06-20-at-3-25-01-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2022-06-20 at 3.25.01 PM.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":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":64742,"type":"discussion","name":"FAQ: What are the functions of the Activity & Moderation categories on my profile?","excerpt":"Activity The Activity category on your profile keeps track of the non-content related activity associated with your account. This includes the badges you earn, your profile updates, and a log of reactions to your posts from other users. Click on the Reaction Icon (such as Insightful) to view the associated posts.…","categoryID":328,"dateInserted":"2019-12-11T19:18:43+00:00","dateUpdated":"2022-06-20T13:59:54+00:00","dateLastComment":"2019-12-11T19:18:43+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":133,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/64742\/faq-what-are-the-functions-of-the-activity-moderation-categories-on-my-profile","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64742\/faq-what-are-the-functions-of-the-activity-moderation-categories-on-my-profile","format":"Rich","groupID":null,"statusID":0,"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":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":64741,"type":"discussion","name":"FAQ: How do I let others know what answer was best?","excerpt":"After someone has responded to your question with a comment, you will notice that under their comment there’s a prompt asking you, Did this answer the question? Yes . No If you click Yes, this answer will appear under a heading that says Best Answer, and your post will have an Accepted answer label next to its title in the…","categoryID":328,"dateInserted":"2019-12-11T19:16:43+00:00","dateUpdated":"2020-10-04T09:28:51+00:00","dateLastComment":"2019-12-11T19:16:43+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":91566,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/T4YLN045Q7TF\/n81H11L2YPG9T.jpg","dateLastActive":"2022-10-21T17:10:27+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":158,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/64741\/faq-how-do-i-let-others-know-what-answer-was-best","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64741\/faq-how-do-i-let-others-know-what-answer-was-best","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/T3WBFO9UQI45\/screen-shot-2020-10-04-at-10-24-02-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2020-10-04 at 10.24.02 AM.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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
@Vane<\/a> <\/p>

If you only want to add those if the Status is Approved, you'd use this formula:<\/p>

=SUMIFS([Approved Change Order Amount.]:[Approved Change Order Amount.], Category:Category, CONTAINS(\"Regulatory Submissions\", @cell), Status:Status, \"Approved\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 21:33:13","updateUser":{"userID":154015,"name":"Vane","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Vane","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T22:08:16+00:00","banned":0,"punished":0,"private":true,"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":96887,"type":"question","name":"Help with COUNTIF","excerpt":"Currently I am counting the number of rows assigned to a particular person using a separate sheet. Currently it counts every row based on the value of the adjacent column. The current entry in the cell that displays the count is =COUNTIF({Sheet - Request Tracker Range 9}, Category26). I need to be able to count the number…","categoryID":322,"dateInserted":"2022-10-21T17:48:50+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T17:59:27+00:00","insertUserID":154002,"insertUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu1VcnmvyGv6lWBPJmcBlo2-f4c9qfr0HlrcGUdo=s96-c","dateLastActive":"2022-10-21T18:00:34+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":"2022-10-21T17:57:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3332750297,"url":"https:\/\/community.smartsheet.com\/discussion\/96887\/help-with-countif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96887\/help-with-countif","format":"Rich","lastPost":{"discussionID":96887,"commentID":348294,"name":"Re: Help with COUNTIF","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348294#Comment_348294","dateInserted":"2022-10-21T17:59:27+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":"2022-10-21T17:57: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-10-21T18:04:48+00:00","dateAnswered":"2022-10-21T17:59:27+00:00","acceptedAnswers":[{"commentID":348294,"body":"

You would switch over to a COUNTIFS to include multiple range\/criteria sets, include the new range, and then include the new criteria.<\/p>

=COUNTIFS<\/strong>({Sheet - Request Tracker Range 9}, Category26, {New Range}, AND(@cell <> \"Closed\", @cell <> \"Cancelled\")<\/strong>)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-21 18:04:48","updateUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu1VcnmvyGv6lWBPJmcBlo2-f4c9qfr0HlrcGUdo=s96-c","dateLastActive":"2022-10-21T18:00:34+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":96879,"type":"question","name":"Plus sign in front of a cell value","excerpt":"We just noticed a plus sign appeared in front of a value in a sheet and when you click on it, it becomes a minus. How did it get there? What does it mean and how do we remove?","categoryID":321,"dateInserted":"2022-10-21T15:29:50+00:00","dateUpdated":null,"dateLastComment":"2022-10-21T16:48:45+00:00","insertUserID":146968,"insertUser":{"userID":146968,"name":"Alta","url":"https:\/\/community.smartsheet.com\/profile\/Alta","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-21T16:49:12+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-10-21T18:40:50+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":24,"score":null,"hot":3332743715,"url":"https:\/\/community.smartsheet.com\/discussion\/96879\/plus-sign-in-front-of-a-cell-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96879\/plus-sign-in-front-of-a-cell-value","format":"Rich","lastPost":{"discussionID":96879,"commentID":348265,"name":"Re: Plus sign in front of a cell value","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348265#Comment_348265","dateInserted":"2022-10-21T16:48:45+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-10-21T18:40:50+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":"2022-10-21T16:42:13+00:00","dateAnswered":"2022-10-21T16:29:04+00:00","acceptedAnswers":[{"commentID":348258,"body":"

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

If you don't want to click on the + sign to expand the Child Rows, I would suggest right-clicking on the column name, then selecting Expand All<\/strong>. <\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n

Then you can see all the rows indented below your current one!<\/p>