Formulas and Functions

The way reports work to add Columns, if the column on one sheet is a Dropdown type column and on another sheet it's a date type column then it will show the columns as two separate ones instead of combining the data into the same column.<\/p>

Could it be that the sheet summary report is doing the same type of thing? What I mean is, it looks like the Sheet Summaries are all formulas. Is it possible that the Status, Solution, Sales Lead, etc columns which aren't coming in for Row 5 is because the formula in Status, Solution, Sales Lead etc for the sheets feeding Rows 1-4 are all the exact same formula but this sheet which is feeding Row 5 has a different formula in those cells than the other sheets?<\/p>

I'm grasping here but I can totally see SmartSheet doing the above thing.<\/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":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"}]},{"discussionID":104885,"type":"question","name":"Health Status Formula","excerpt":"Hi! Currently, I have a formula in place to indicate R,Y,G Health based on the Start\/Due Date. Is it possible to add an =OR function so that if \"Status\" column is switched to complete the Health will indicate green. Sorry .. very new to this.","categoryID":322,"dateInserted":"2023-05-05T12:54:38+00:00","dateUpdated":null,"dateLastComment":"2023-05-05T13:50:56+00:00","insertUserID":161143,"insertUser":{"userID":161143,"name":"lukas.johnson","title":"TGT AP","url":"https:\/\/community.smartsheet.com\/profile\/lukas.johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T14:25:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161143,"lastUser":{"userID":161143,"name":"lukas.johnson","title":"TGT AP","url":"https:\/\/community.smartsheet.com\/profile\/lukas.johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T14:25:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":34,"score":null,"hot":3366588334,"url":"https:\/\/community.smartsheet.com\/discussion\/104885\/health-status-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104885\/health-status-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":104885,"commentID":374597,"name":"Re: Health Status Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/374597#Comment_374597","dateInserted":"2023-05-05T13:50:56+00:00","insertUserID":161143,"insertUser":{"userID":161143,"name":"lukas.johnson","title":"TGT AP","url":"https:\/\/community.smartsheet.com\/profile\/lukas.johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T14:25:30+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/RS6IHUI5BST2\/2-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-05T13:50:30+00:00","dateAnswered":"2023-05-05T13:48:49+00:00","acceptedAnswers":[{"commentID":374596,"body":"

You are missing the 2nd \"If\" in bold: <\/p>

=If(Status@row=\"Complete\", \"Green\", IF<\/strong>([Due<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":104869,"type":"question","name":"CountIf result explanation","excerpt":"I have a series of formula that I am attempting to use to split a compound part number into its part number and revision number and then throw an alert if duplicates are found. Unfortunately my function is returning unpredictable results and I was hoping someone could explain it to me. You will see in the first image, a…","categoryID":322,"dateInserted":"2023-05-04T21:09:31+00:00","dateUpdated":null,"dateLastComment":"2023-05-05T15:50:30+00:00","insertUserID":158449,"insertUser":{"userID":158449,"name":"Kevin De Hart","url":"https:\/\/community.smartsheet.com\/profile\/Kevin%20De%20Hart","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T16:19:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":15741,"lastUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T21:37:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":31,"score":null,"hot":3366538801,"url":"https:\/\/community.smartsheet.com\/discussion\/104869\/countif-result-explanation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104869\/countif-result-explanation","format":"Rich","lastPost":{"discussionID":104869,"commentID":374619,"name":"Re: CountIf result explanation","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/374619#Comment_374619","dateInserted":"2023-05-05T15:50:30+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-05T21:37:18+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/K1AZK74IQG1B\/count-not-working-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Count not working.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-05T13:32:54+00:00","dateAnswered":"2023-05-04T21:48:01+00:00","acceptedAnswers":[{"commentID":374546,"body":"

I've run into this a few times, and honestly not sure what causes it to happen. But the solution I've found is if you add a helper column, something as simple as<\/p>

=\"A\" + Part@row<\/p>

And then do your COUNTIF off of that helper column it should be OK. I imagine it has something to do with SS not being able to recognize whether that split string is a text or number... but it should still at least be able to count itself!<\/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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">