Formulas and Functions

Actual % Complete then the task is “Late”, “Red Ball”. IF “On schedule % Complete is < Actual % Complete then the task is “On track”, “Green Ball”. IF “On schedule % Complete is = 0% (Actual %…","categoryID":322,"dateInserted":"2020-10-04T03:17:24+00:00","dateUpdated":null,"dateLastComment":"2020-10-04T16:38:54+00:00","insertUserID":122394,"insertUser":{"userID":122394,"name":"Steve Akana","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Akana","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ha9XYSMwN3Q!k4FXH3NcQ3w!bBo4RKmWi4g","dateLastActive":"2022-03-11T21:38:41+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":121890,"lastUser":{"userID":121890,"name":"Ramzi K","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ramzi%20K","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/SANQ6N8O1FSK\/n1MST7KW5A43V.png","dateLastActive":"2023-07-13T13:13:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":217,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/71878\/actual-complete-vs-on-schedule-complete","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71878\/actual-complete-vs-on-schedule-complete","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/92WOS8SB0QA2\/smartsheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet.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":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":69677,"type":"question","name":"Formula on Smartsheets not autopopulating","excerpt":"I have a Smartsheet that has formulas setup in the first two rows of the sheet. I have data on an Excel that needs to be copied and pasted onto this sheet. On copying and pasting upto 20 rows, Smartsheet has continued to maintain the formulas without any issue. However if I copied more than 20 rows, the formulas dont seem…","categoryID":322,"dateInserted":"2020-07-08T02:52:19+00:00","dateUpdated":null,"dateLastComment":"2020-10-04T13:02:42+00:00","insertUserID":123911,"insertUser":{"userID":123911,"name":"S.GC.Bot4.d.whq User","url":"https:\/\/community.smartsheet.com\/profile\/S.GC.Bot4.d.whq%20User","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-03T05:33:22+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-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":62,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/69677\/formula-on-smartsheets-not-autopopulating","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69677\/formula-on-smartsheets-not-autopopulating","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"}],"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":70653,"type":"question","name":"Keeping formulas when pasting rows of data","excerpt":"I',m in a bit of a pickle with one of our sheets. So right now I've got a sheet that is being filled in automatically with a script that I made. It is taking a CSV that is constantly growing, converting it into an excel doc, and then copying & pasting the entire thing into a smartsheet. This works great for the most part,…","categoryID":322,"dateInserted":"2020-08-17T20:45:00+00:00","dateUpdated":"2020-08-17T20:55:59+00:00","dateLastComment":"2020-10-04T12:48:58+00:00","insertUserID":96141,"insertUser":{"userID":96141,"name":"samgiese","url":"https:\/\/community.smartsheet.com\/profile\/samgiese","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-18T15:28:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":96141,"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-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":72,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/70653\/keeping-formulas-when-pasting-rows-of-data","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70653\/keeping-formulas-when-pasting-rows-of-data","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/AR8Q4988H0AP\/image.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"}],"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":71709,"type":"question","name":"Filter data on dashboard report","excerpt":"Hello! I have a report listing application statuses (approved, in process, declined) and agreement statuses (executed, in process, canceled) as a widget on my dashboard, and one of team members would like the ability filter by status. Is this something possible to do?","categoryID":322,"dateInserted":"2020-09-29T21:41:01+00:00","dateUpdated":null,"dateLastComment":"2020-10-04T05:24:44+00:00","insertUserID":126814,"insertUser":{"userID":126814,"name":"Olivia Halas","url":"https:\/\/community.smartsheet.com\/profile\/Olivia%20Halas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-01-29T22:27:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":127108,"lastUser":{"userID":127108,"name":"Nicole Worobel","url":"https:\/\/community.smartsheet.com\/profile\/Nicole%20Worobel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-11-12T15:42:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":360,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/71709\/filter-data-on-dashboard-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/71709\/filter-data-on-dashboard-report","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":[],"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