\n <\/img><\/a>\n <\/div>\n<\/div>\nHope this helps - any issues etc. then just post! 😊<\/span><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":107018,"type":"question","name":"ROI Calculation Formula","excerpt":"I have a sheet that gathers numbers for various project costs and for various values. There are two columns that sum each of these; Total Costs and Total Value. I am using the following formula to calculate the ROI: =([Total Value]@row - [Total Costs]@row) \/ [Total Costs]@row * 100 However, the calculation seems to be off.…","snippet":"I have a sheet that gathers numbers for various project costs and for various values. There are two columns that sum each of these; Total Costs and Total Value. I am using the…","categoryID":322,"dateInserted":"2023-06-28T14:24:22+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T15:14:39+00:00","insertUserID":159640,"insertUser":{"userID":159640,"name":"Katherine Simpson","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Simpson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/EY1XYADLUP90\/n8693BY7J2F39.jpg","dateLastActive":"2023-06-28T15:13:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159640,"lastUser":{"userID":159640,"name":"Katherine Simpson","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Simpson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/EY1XYADLUP90\/n8693BY7J2F39.jpg","dateLastActive":"2023-06-28T15:13:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3375928741,"url":"https:\/\/community.smartsheet.com\/discussion\/107018\/roi-calculation-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107018\/roi-calculation-formula","format":"Rich","lastPost":{"discussionID":107018,"commentID":382858,"name":"Re: ROI Calculation Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382858#Comment_382858","dateInserted":"2023-06-28T15:14:39+00:00","insertUserID":159640,"insertUser":{"userID":159640,"name":"Katherine Simpson","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Simpson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/EY1XYADLUP90\/n8693BY7J2F39.jpg","dateLastActive":"2023-06-28T15:13:49+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":"2023-06-28T15:14:06+00:00","dateAnswered":"2023-06-28T14:56:38+00:00","acceptedAnswers":[{"commentID":382852,"body":"Try omitting the \"*100\" at the end of your formula. Convert the column to show the number as a percentage. <\/p>
\n
\n
\n <\/img><\/a>\n <\/div>\n<\/div>\n <\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending in Formulas and Functions
How to subtract percentages? I created a new column % Not complete and am trying to add a formula to have =100%-[%Complete]@row. Answer #UNPARSEABLE I have also tried =100-%Complete]@row. Answer: This will populate an answer, however I cannot adjust the formatting from % to number Example: %Complete = 13% Correct answer should display 87% Second…
I need help with a if formula to get the $ amount total if another column = a specific item. I want to make a formula in the Column "A Total" in the highlighted Cell, that will give me the Sum of $ from Grand Total Column if the A is in the Project column.
ROI Calculation Formula I have a sheet that gathers numbers for various project costs and for various values. There are two columns that sum each of these; Total Costs and Total Value. I am using the following formula to calculate the ROI: =([Total Value]@row - [Total Costs]@row) / [Total Costs]@row * 100 However, the calculation seems to be off.…