Formulas and Functions

REQUESTED@row, 1) I would like to get a flag if the [sign off on]…","categoryID":322,"dateInserted":"2021-04-15T20:54:16+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T17:59:42+00:00","insertUserID":121998,"insertUser":{"userID":121998,"name":"Mily Oti","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mily%20Oti","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n7ZG0TBD44T33.png","dateLastActive":"2021-10-27T14:56:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":121998,"lastUser":{"userID":121998,"name":"Mily Oti","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mily%20Oti","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n7ZG0TBD44T33.png","dateLastActive":"2021-10-27T14:56:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":61,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/78416\/date-comparison-if-greater-than-30-then-flag","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78416\/date-comparison-if-greater-than-30-then-flag","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-16T17:59:47+00:00","dateAnswered":"2021-04-16T17:59:42+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":78365,"type":"question","name":"Average If using a list rather than a range","excerpt":"I need to take an average if the data is greater than zero. I got it covered when the data is neatly organized in a range: =AVERAGEIF([Chart Data]79:[Chart Data]82, >0, [Chart Data]79:[Chart Data]82). My issue comes in when I try the same formula for cells dispersed throughout the sheet. I need to add the average if not…","categoryID":322,"dateInserted":"2021-04-14T18:46:49+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T17:43:40+00:00","insertUserID":121934,"insertUser":{"userID":121934,"name":"Jared Davis","url":"https:\/\/community.smartsheet.com\/profile\/Jared%20Davis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/VHOYVINJSUX0\/n97I7UA0P0O42.jpg","dateLastActive":"2022-02-24T22:05:04+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":146,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/78365\/average-if-using-a-list-rather-than-a-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78365\/average-if-using-a-list-rather-than-a-range","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/SOOOI7N75DD2\/cell-list-instead-of-range.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Cell list instead of range.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-15T15:17:03+00:00","dateAnswered":"2021-04-14T20:21:53+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":78462,"type":"question","name":"Formula Looking at 2 Dates","excerpt":"Hi! I'm working to track whether or not the need by date entered on request forms abide by our 7-business day SLA. The goal is to see out of the requests that were not completed by the need by date, how many of those requests were outside of our SLA. I need a formula where, If the [Need By Date] column is at least…","categoryID":322,"dateInserted":"2021-04-16T17:29:53+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T17:37:20+00:00","insertUserID":121348,"insertUser":{"userID":121348,"name":"Taylor Riley","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Taylor%20Riley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/699\/nFGTTYSMFCH0Z.jpg","dateLastActive":"2022-03-04T00:48:14+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/78462\/formula-looking-at-2-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78462\/formula-looking-at-2-dates","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-16T17:37:20+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":67941,"type":"question","name":"Convert duration in a number column to make calculations","excerpt":"How could I covert the duration information\/data in number so I can calculate variances in numbers or in percentages? I had to create a column and type each number, but I can not do that in 50 different worksheets. Is there any formula that can convert the duration days in real numbers so I can use it for additional…","categoryID":322,"dateInserted":"2020-04-30T20:37:05+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T17:07:43+00:00","insertUserID":121101,"insertUser":{"userID":121101,"name":"MYRIAMMC","url":"https:\/\/community.smartsheet.com\/profile\/MYRIAMMC","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-06-07T19:00:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":135112,"lastUser":{"userID":135112,"name":"Manzar Ahmed","url":"https:\/\/community.smartsheet.com\/profile\/Manzar%20Ahmed","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-21T17:23:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":959,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/67941\/convert-duration-in-a-number-column-to-make-calculations","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67941\/convert-duration-in-a-number-column-to-make-calculations","format":"rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/505\/9RAPK47QMKT0.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Convert duration in numbers.JPG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-05-01T11:16:17+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":78398,"type":"question","name":"Comparing dates","excerpt":"Hi, is there a way to compare dates in several columns (in the same sheet) and determine the earliest or latest date from the set? Thanks in advance. -Zia","categoryID":322,"dateInserted":"2021-04-15T16:06:04+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T16:00:11+00:00","insertUserID":135039,"insertUser":{"userID":135039,"name":"Zia Siddiqui","url":"https:\/\/community.smartsheet.com\/profile\/Zia%20Siddiqui","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgqwKjXbFipPzFkTcSdT_2I1ms38F3IOLaL_CsN=s96-c","dateLastActive":"2021-06-16T23:15:53+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":134,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/78398\/comparing-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78398\/comparing-dates","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-16T15:40:02+00:00","dateAnswered":"2021-04-16T15:37:45+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":78447,"type":"question","name":"Countifs with Multiple instances (not a drop down)","excerpt":"Happy Friday everyone, I currently have a working formula in a rollup sheet that counts one instance. The new request is to have it count multiple instances between a specific date where a box is not checked. I can get it to count the one selection but when I attempt to replicate within the formula to count multiple, it…","categoryID":322,"dateInserted":"2021-04-16T14:00:31+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T15:59:19+00:00","insertUserID":122147,"insertUser":{"userID":122147,"name":"Tabitha W.","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Tabitha%20W.","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucp-VA6ITuZCDqDxtXNiztTSe6_bkp587rKAuncTow=s96-c","dateLastActive":"2022-08-24T20:01:52+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":61,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/78447\/countifs-with-multiple-instances-not-a-drop-down","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78447\/countifs-with-multiple-instances-not-a-drop-down","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-16T15:45:02+00:00","dateAnswered":"2021-04-16T15:40:04+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":78453,"type":"question","name":"How can I fix the error #UNPARSEABLE","excerpt":"=IF(Aged@row > Terms@row, \"Red\", IF(Aged@row = Terms@row, \"Yellow\", IF(Aged@row < Terms@row, \"Green\",IF(Payment Status@row=\"Yes\",\"Green\"))))","categoryID":322,"dateInserted":"2021-04-16T14:46:18+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T14:52:47+00:00","insertUserID":135102,"insertUser":{"userID":135102,"name":"Sherika Burton","url":"https:\/\/community.smartsheet.com\/profile\/Sherika%20Burton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-22T16:36:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":135102,"lastUser":{"userID":135102,"name":"Sherika Burton","url":"https:\/\/community.smartsheet.com\/profile\/Sherika%20Burton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-04-22T16:36:19+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":412,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/78453\/how-can-i-fix-the-error-unparseable","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78453\/how-can-i-fix-the-error-unparseable","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-16T15:15:34+00:00","dateAnswered":"2021-04-16T14:52:47+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":78451,"type":"question","name":"Display Value from Today","excerpt":"Each day we enter the number of new employees by type. In that sheet, I'd like to display the value from today. I have a date column called Day and a column called Intern. I want the summary filed to display the number as it changed each day. I've tried various forms of Vlookup, Index and Max with no luck. Thanks for your…","categoryID":322,"dateInserted":"2021-04-16T14:38:49+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T14:46:14+00:00","insertUserID":131616,"insertUser":{"userID":131616,"name":"Andrea Westrich","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Westrich","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!06vS_zj5Rrw!!Vj-bj4lNhSM","dateLastActive":"2023-08-23T17:05:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":131616,"lastUser":{"userID":131616,"name":"Andrea Westrich","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Westrich","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!06vS_zj5Rrw!!Vj-bj4lNhSM","dateLastActive":"2023-08-23T17:05:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":62,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/78451\/display-value-from-today","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78451\/display-value-from-today","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-16T14:42:14+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":78446,"type":"question","name":"My column formula =COUNT(DESCENDANTS()) returns #BLOCKED in one cell. Is there a limit to the count?","excerpt":"All other column formulas work fine. The only reason I can think of is there may be too many descendants? The value returned should be 1540. Is there a limit to the COUNT function?","categoryID":322,"dateInserted":"2021-04-16T13:57:48+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T14:17:01+00:00","insertUserID":62471,"insertUser":{"userID":62471,"name":"bourgeoj","url":"https:\/\/community.smartsheet.com\/profile\/bourgeoj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/HFJAQU9IR1ZJ\/nO8ABLP2ZQAFB.jpg","dateLastActive":"2023-04-19T19:06:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":62471,"lastUser":{"userID":62471,"name":"bourgeoj","url":"https:\/\/community.smartsheet.com\/profile\/bourgeoj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/HFJAQU9IR1ZJ\/nO8ABLP2ZQAFB.jpg","dateLastActive":"2023-04-19T19:06:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":96,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/78446\/my-column-formula-count-descendants-returns-blocked-in-one-cell-is-there-a-limit-to-the-count","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78446\/my-column-formula-count-descendants-returns-blocked-in-one-cell-is-there-a-limit-to-the-count","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-04-16T14:17:12+00:00","dateAnswered":"2021-04-16T14:17:01+00:00","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":78402,"type":"question","name":"Workflow - Option to Add a Comment","excerpt":"We have a workflow set up that can either be Approved or Declined. However, if Declined we need an automated option for the user to comment why its declined. Any suggestions on how to do this? (Besides a separate email to request an update to comment on a row. The goal is to have this all in one step if possible)","categoryID":322,"dateInserted":"2021-04-15T16:50:17+00:00","dateUpdated":null,"dateLastComment":"2021-04-16T13:04:44+00:00","insertUserID":8777,"insertUser":{"userID":8777,"name":"Laura","url":"https:\/\/community.smartsheet.com\/profile\/Laura","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/0e\/35\/n0e35051e93891757bdff0c739bba89cc.jpg","dateLastActive":"2021-09-22T14:54:40+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":500,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/78402\/workflow-option-to-add-a-comment","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/78402\/workflow-option-to-add-a-comment","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-04-15T16:56:58+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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}">

Help Article Resources