functionality

=\" [Flu Vaccination Date]$1 OR If [Flu Declination Date] is \"Blank\" OR If [Flu Declination Date] is \">=\" [Flu…","categoryID":322,"dateInserted":"2020-01-22T06:23:56+00:00","dateUpdated":null,"dateLastComment":"2020-01-22T21:09:29+00:00","insertUserID":94806,"insertUser":{"userID":94806,"name":"raymond.j.riosiii94806","url":"https:\/\/community.smartsheet.com\/profile\/raymond.j.riosiii94806","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nhFeXyKlF_s!wdPfsDq3z_8!GGUOvOAr_35","dateLastActive":"2023-06-09T22:23:28+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":"2023-06-13T17:57:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":75,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/65396\/nest-if-or-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65396\/nest-if-or-formula","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/425\/0J135164NN5D.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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}]},{"discussionID":65371,"type":"question","name":"Is there any possibilities to get the Webhook data when someone make a request to access the sheet?","excerpt":"Hi, we are using Smartsheet's webhook API. We have the following use case. Consider user 'A' registered a webhook on a particular sheet. When some other Smartsheet user 'B' who has URL of the sheet of the user 'A' and tried to access the sheet its shows \"Request Acess\" and when the user 'B' clicks on request access, the…","categoryID":320,"dateInserted":"2020-01-21T10:30:20+00:00","dateUpdated":null,"dateLastComment":"2020-01-22T19:10:58+00:00","insertUserID":116709,"insertUser":{"userID":116709,"name":"Anurag T","url":"https:\/\/community.smartsheet.com\/profile\/Anurag%20T","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-01-21T11:53:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-13T18:13:34+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":105,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/65371\/is-there-any-possibilities-to-get-the-webhook-data-when-someone-make-a-request-to-access-the-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65371\/is-there-any-possibilities-to-get-the-webhook-data-when-someone-make-a-request-to-access-the-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"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}]},{"discussionID":65355,"type":"question","name":"Using COUNTIF to determine dept. but excluding projects that are HOLD Status","excerpt":"I can't figure out how to do this formula and I've been searching for it in community. I've tried the following: =COUNTIFS(Portfolio Rollups Range 1, \"Corp IT\",AND({Portfolio Rollups Range 8},=\"In Progress\",{Portfolio Rollups Range 8},=\"Complete\") This one returns unparsable =COUNTIFS({Portfolio Rollups Range 4}, \"Yellow\",…","categoryID":322,"dateInserted":"2020-01-20T18:43:34+00:00","dateUpdated":null,"dateLastComment":"2020-01-22T18:58:40+00:00","insertUserID":107046,"insertUser":{"userID":107046,"name":"Shawn Borror","url":"https:\/\/community.smartsheet.com\/profile\/Shawn%20Borror","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-25T16:34:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-13T18:13:34+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":98,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/65355\/using-countif-to-determine-dept-but-excluding-projects-that-are-hold-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65355\/using-countif-to-determine-dept-but-excluding-projects-that-are-hold-status","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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}]},{"discussionID":65416,"type":"discussion","name":"WEEKNUMBER and WEEKDAY","excerpt":"I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date\/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) to see who's \"on duty\" at that time. That contact's name is pulled into an \"Assigned\"…","categoryID":322,"dateInserted":"2020-01-22T18:54:01+00:00","dateUpdated":null,"dateLastComment":"2020-01-22T18:54:01+00:00","insertUserID":116954,"insertUser":{"userID":116954,"name":"Michael Palko","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Palko","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nZFXf6c_E3o!pgNW6Rd9t3o!_CRiXtBq7QQ","dateLastActive":"2020-09-25T18:29:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":116954,"lastUser":{"userID":116954,"name":"Michael Palko","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Palko","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nZFXf6c_E3o!pgNW6Rd9t3o!_CRiXtBq7QQ","dateLastActive":"2020-09-25T18:29:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1216,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/65416\/weeknumber-and-weekday","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65416\/weeknumber-and-weekday","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/451\/9R60E4UFPHEH.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Weeknumber.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"tagID":241,"urlcode":"Calendar","name":"Calendar View"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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":65365,"type":"question","name":"Automatically add formula to new row & apply @row to look at row above","excerpt":"I have my cashflow forecast on Smartsheet, and i have a formula which looks at the balance on the row above to apply the balance for the current row as follows =BALANCE1350 + [in's]1351 - [out's]@row. When i shift the row up or down within the sheet, it keeps looking the the balance original balance on the row that was…","categoryID":322,"dateInserted":"2020-01-20T23:56:23+00:00","dateUpdated":null,"dateLastComment":"2020-01-22T18:48:29+00:00","insertUserID":75241,"insertUser":{"userID":75241,"name":"AbbyT","url":"https:\/\/community.smartsheet.com\/profile\/AbbyT","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-03-23T18:41:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":75241,"lastUser":{"userID":75241,"name":"AbbyT","url":"https:\/\/community.smartsheet.com\/profile\/AbbyT","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-03-23T18:41:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":447,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/65365\/automatically-add-formula-to-new-row-apply-row-to-look-at-row-above","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65365\/automatically-add-formula-to-new-row-apply-row-to-look-at-row-above","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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}">