@Paige_Hamby<\/a> <\/p>I will admit, I was \"Completely Stumped\" for a moment as well... but I believe this should work.<\/p>
=IF(COUNTIFS({Customer Name}, Customer@row, {Document Type}, \"Upsell\", {Item Purchase}, HAS(@cell, \"SummitIT Upsell\")) > 0, \"Upsell\", \"//www.santa-greenland.com/community/discussion/5826/\")<\/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":106262,"type":"question","name":"If Function - Nested - Negative Percentage - Symbols","excerpt":"I have a formula that is driving me insane. I am trying to get symbols to change color based on the % to Plan column (see screenshot). If the % is positive, I want the On Track Column to show Green. If it is negative BUT greater than -25%, I would like to show Yellow and all others to show Red. The problem is I am getting…","categoryID":322,"dateInserted":"2023-06-09T13:24:56+00:00","dateUpdated":"2023-06-09T13:26:23+00:00","dateLastComment":"2023-06-09T17:38:55+00:00","insertUserID":133646,"insertUser":{"userID":133646,"name":"Erica Maynard","url":"https:\/\/community.smartsheet.com\/profile\/Erica%20Maynard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xRlVcbcPL7o!zQ9WM1MTznw!fPD-lu3hQ7z","dateLastActive":"2023-06-09T17:39:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":91566,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-09T21:23:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":36,"score":null,"hot":3372654831,"url":"https:\/\/community.smartsheet.com\/discussion\/106262\/if-function-nested-negative-percentage-symbols","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106262\/if-function-nested-negative-percentage-symbols","format":"Rich","lastPost":{"discussionID":106262,"commentID":379895,"name":"Re: If Function - Nested - Negative Percentage - Symbols","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379895#Comment_379895","dateInserted":"2023-06-09T17:38:55+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-09T21:23:26+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\/UP55UNVW485J\/smartsheet-error.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet - Error.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T17:40:06+00:00","dateAnswered":"2023-06-09T17:30:55+00:00","acceptedAnswers":[{"commentID":379893,"body":"
This situation would be appropriate for a column formula. I would try pasting Ray's formula from above into the first cell of the column and then converting to a column formula.<\/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 Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
