\n https:\/\/youtu.be\/bmxQhhMONFY\n <\/a>\n<\/div>
<\/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"}]},{"discussionID":106403,"type":"question","name":"Sheet Reference Comparing two Totals to determine Indicator","excerpt":"Hello, I am working on a formula where I am referencing one sheet with numbers to set an indicator on another, to determine if something is Red, yellow or green. I am using a single cell called difference on my reference Sheet. The code should read if Less than 20,000.00 it should be Red, greater than 100,000.00 should be…","categoryID":322,"dateInserted":"2023-06-13T21:52:58+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T16:27:21+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T16:31:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162256,"lastUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T16:31:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":3373455619,"url":"https:\/\/community.smartsheet.com\/discussion\/106403\/sheet-reference-comparing-two-totals-to-determine-indicator","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106403\/sheet-reference-comparing-two-totals-to-determine-indicator","format":"Rich","lastPost":{"discussionID":106403,"commentID":380537,"name":"Re: Sheet Reference Comparing two Totals to determine Indicator","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380537#Comment_380537","dateInserted":"2023-06-14T16:27:21+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T16:31:35+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\/911A3ILQ203M\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-14T16:28:22+00:00","dateAnswered":"2023-06-14T13:11:32+00:00","acceptedAnswers":[{"commentID":380461,"body":"
Putting quotes around numbers in a formula changes it to a text string (which can't be less than or greater than a number).<\/p>
<\/p>
Try removing the quotes from the numbers and putting them around the colors.<\/p>
<\/p>
I also notice that your quotes are slanted. Unless you have them \"italicized\", these are the wrong types of quotes.<\/p>
They are called \"smart quotes\" which (ironically enough) are not valid characters in a Smartsheet formula. You are going to want to retype them here, in Smartsheet directly, or in a text editor such as Notepad (not Word). You will see that typing them in the previously mentioned places have them straight up and down. These are the quotes you are looking for.<\/p>"},{"commentID":380535,"body":"
特拉维斯 员工
