Formulas and Functions

Link to send…","categoryID":322,"dateInserted":"2021-01-30T16:55:14+00:00","dateUpdated":"2021-01-30T16:58:54+00:00","dateLastComment":"2021-02-01T07:20:20+00:00","insertUserID":127181,"insertUser":{"userID":127181,"name":"James Keuning","title":"","url":"https:\/\/community.smartsheet.com\/profile\/James%20Keuning","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-10T12:40:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":127181,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-07-12T20:38:27+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\/75517\/can-i-create-a-hyperlink-by-combining-text-strings-and-fielded-data-pretty-basic-parameter-work","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75517\/can-i-create-a-hyperlink-by-combining-text-strings-and-fielded-data-pretty-basic-parameter-work","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-02-01T07:20: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":[{"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":75533,"type":"question","name":"Formula to change line item to 'at risk' when due date is passed","excerpt":"Goal: When a finish date is passed on a line item, I want the status column to change to 'at risk'.","categoryID":322,"dateInserted":"2021-02-01T02:31:21+00:00","dateUpdated":null,"dateLastComment":"2021-02-01T04:31:46+00:00","insertUserID":131379,"insertUser":{"userID":131379,"name":"Daniel Marcel","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Marcel","photoUrl":"https:\/\/lh3.googleusercontent.com\/-2IrmQOg6VnY\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuucmWKibY_8EnjgE0QPU-0Ingqo-2XQ\/s96-c\/photo.jpg","dateLastActive":"2021-04-08T22:26:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":131379,"lastUser":{"userID":131379,"name":"Daniel Marcel","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Marcel","photoUrl":"https:\/\/lh3.googleusercontent.com\/-2IrmQOg6VnY\/AAAAAAAAAAI\/AAAAAAAAAAA\/AMZuucmWKibY_8EnjgE0QPU-0Ingqo-2XQ\/s96-c\/photo.jpg","dateLastActive":"2021-04-08T22:26:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":144,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/75533\/formula-to-change-line-item-to-at-risk-when-due-date-is-passed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75533\/formula-to-change-line-item-to-at-risk-when-due-date-is-passed","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/CA5636WLF2XF\/screen-shot-2021-02-01-at-1-13-28-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2021-02-01 at 1.13.28 pm.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-01T02:50:54+00:00","dateAnswered":"2021-02-01T02:44:16+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":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":75405,"type":"question","name":"I would like to count the aging but I'm getting #UNPARSEABLE in this formula.","excerpt":"","categoryID":322,"dateInserted":"2021-01-28T03:03:12+00:00","dateUpdated":null,"dateLastComment":"2021-02-01T04:30:59+00:00","insertUserID":114322,"insertUser":{"userID":114322,"name":"Maryjo Reyes","url":"https:\/\/community.smartsheet.com\/profile\/Maryjo%20Reyes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-26T03:14:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":126171,"lastUser":{"userID":126171,"name":"Mark Cronk","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Cronk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9UVGVH5TN00I\/nO060PSRF4UVU.jpg","dateLastActive":"2023-05-10T19:07:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":153,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/75405\/i-would-like-to-count-the-aging-but-im-getting-unparseable-in-this-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75405\/i-would-like-to-count-the-aging-but-im-getting-unparseable-in-this-formula","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JTMOXMEW8NXJ\/1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"1.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-01T03:00:35+00:00","dateAnswered":"2021-01-29T01:03:30+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":75525,"type":"question","name":"ISBLANK or 0 (ZERO) : Formula for a column","excerpt":"Good afternoon, I have the following formula that is populating my \"HRS Left\" column =IF(OR(ISBLANK(BAC@row), ISBLANK(HTD@row)), BAE@row, SUM(BAC@row - HTD@row)). But I need to be able to write the formula so that the \"HRS Left\" column will populate if my \"HTD\" or \"BAC\" column is \"0\" (zero) or ISBLANK Thank you","categoryID":322,"dateInserted":"2021-01-31T19:33:42+00:00","dateUpdated":null,"dateLastComment":"2021-02-01T03:05:13+00:00","insertUserID":77531,"insertUser":{"userID":77531,"name":"BESP10","url":"https:\/\/community.smartsheet.com\/profile\/BESP10","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtfxL_dcTEjbAHx-0E2pCB2Vy2vl1fdLTYcmHNcatXRM=s96-c","dateLastActive":"2023-07-12T14:35:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":126171,"lastUser":{"userID":126171,"name":"Mark Cronk","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Cronk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9UVGVH5TN00I\/nO060PSRF4UVU.jpg","dateLastActive":"2023-05-10T19:07:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":81,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/75525\/isblank-or-0-zero-formula-for-a-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75525\/isblank-or-0-zero-formula-for-a-column","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/LRRWLRMOH4NF\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2021-02-01T17:50:19+00:00","dateAnswered":"2021-02-01T03:05:13+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