@Christina S.<\/a> <\/p>Switch your formula to:<\/p>
=[Spanish Qty Baseline]# - (COUNTIFS({Brochure Requests Sheet Request Completed}, 1, {Brochure Requests Sheet Request Denied}, ISBLANK(@cell), {Brochure Requests Sheet Brochures Confirmation}, CONTAINS(\"Spanish Brochures\", @cell), {Brochure Requests Sheet Submission Date}, >DATE(2023, 6, 8)) * 100)<\/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":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"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-09T18:59:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":34,"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-09T18:59:15+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":[]},{"discussionID":106269,"type":"question","name":"Organizing Smartsheets into folders - Impact to DVs and WorkApps","excerpt":"Hello, I'm trying to organize the workspace listing in Smartsheet. If I create folders and move sheets into different folders, will that mess anything up for the Dynamic Views and WorkApp? Thanks, Frank","categoryID":321,"dateInserted":"2023-06-09T14:20:40+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T15:35:26+00:00","insertUserID":158554,"insertUser":{"userID":158554,"name":"Frank B.","url":"https:\/\/community.smartsheet.com\/profile\/Frank%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3HVYSSRAF5R9\/n9CDGKLAHBDUI.png","dateLastActive":"2023-06-09T15:34:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":116407,"lastUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-09T17:12:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":17,"score":null,"hot":3372645966,"url":"https:\/\/community.smartsheet.com\/discussion\/106269\/organizing-smartsheets-into-folders-impact-to-dvs-and-workapps","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106269\/organizing-smartsheets-into-folders-impact-to-dvs-and-workapps","format":"Rich","tagIDs":[371,443],"lastPost":{"discussionID":106269,"commentID":379859,"name":"Re: Organizing Smartsheets into folders - Impact to DVs and WorkApps","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379859#Comment_379859","dateInserted":"2023-06-09T15:35:26+00:00","insertUserID":116407,"insertUser":{"userID":116407,"name":"Darren Mullen","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Darren%20Mullen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9WIC1TB7AJQT\/nP1GU5H4ITA1P.png","dateLastActive":"2023-06-09T17:12:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T15:36:14+00:00","dateAnswered":"2023-06-09T15:35:26+00:00","acceptedAnswers":[{"commentID":379859,"body":"
@Frank B.<\/a> If the folders are in the same Workspace that the sheets currently reside, there will for sure be no impact.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":371,"urlcode":"WorkApps","name":"WorkApps"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
