销售

0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…","categoryID":318,"dateInserted":"2016-09-26T01:45:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-09-26T17:47:48+00:00","insertUserID":8452,"insertUser":{"userID":8452,"name":"Matthew Anthon","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20Anthon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-08T19:01:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8452,"lastUser":{"userID":8452,"name":"Matthew Anthon","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20Anthon","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-10-08T19:01:00+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":14626,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/6153\/using-and-and-isblank-in-nested-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6153\/using-and-and-isblank-in-nested-if-statement","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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}]},{"discussionID":6146,"type":"discussion","name":"When will the API get some attention?","excerpt":"I'm using the smartsheet library, and it works pretty well, except that checkboxes always return None, no matter the value. I submitted a bug to the repo on github, and linked it to some other folks that noted the same problem on StackOverflow. For the tool I'm trying to build, I really need that feature to work, or at…","categoryID":318,"dateInserted":"2016-09-23T23:15:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-09-26T17:21:20+00:00","insertUserID":8444,"insertUser":{"userID":8444,"name":"Lincoln Lorscheider","url":"https:\/\/community.smartsheet.com\/profile\/Lincoln%20Lorscheider","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-09-23T23:10:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":216,"lastUser":{"userID":216,"name":"Alex Vorobiev","url":"https:\/\/community.smartsheet.com\/profile\/Alex%20Vorobiev","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-26T13:32:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":4,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/6146\/when-will-the-api-get-some-attention","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6146\/when-will-the-api-get-some-attention","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":218,"urlcode":"Construction","name":"Construction"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":5984,"type":"discussion","name":"New Client Sheet Generator?","excerpt":"Hello, I have a Web Form which Account Managers complete when a new client is to be added to a 3rd party tool. This data transfers to a smartsheet where an email is sent to our 3rd party tool notifying them there is a new client. This data contains the client name, address, phone, email, and POC. At this point, I am…","categoryID":318,"dateInserted":"2016-09-02T17:48:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-09-25T22:50:47+00:00","insertUserID":8191,"insertUser":{"userID":8191,"name":"Debbie McKay GLP GTP CCTE","url":"https:\/\/community.smartsheet.com\/profile\/Debbie%20McKay%20GLP%20GTP%20CCTE","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-11-11T13:19:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":14,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5984\/new-client-sheet-generator","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5984\/new-client-sheet-generator","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":271,"urlcode":"Services","name":"Services"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]},{"discussionID":5995,"type":"discussion","name":"Result look up","excerpt":"Hi, I am a beginer at using Smartsheet however have been successful to date in creating a workable module for my sales team, however, within one of my module sheets I have a list sales attributed to sales staff which uses a Decision drop down list \"yes\" symbol indicating a sale has been completed. My question is, how can I…","categoryID":318,"dateInserted":"2016-09-05T21:41:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-09-06T09:22:15+00:00","insertUserID":8207,"insertUser":{"userID":8207,"name":"John Ovcaric","url":"https:\/\/community.smartsheet.com\/profile\/John%20Ovcaric","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-09-05T21:32:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7721,"lastUser":{"userID":7721,"name":"Tony Davidson - SmartSheet Certified User 2016","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Davidson%20-%20SmartSheet%20Certified%20User%202016","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-23T15:04:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5995\/result-look-up","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5995\/result-look-up","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":5903,"type":"discussion","name":"Collaboration outside our organisation","excerpt":"we want to collaborate on certain rows but not all rows with an external partner. is there a way we can do this without sharing all the rows in a Smartsheet?","categoryID":318,"dateInserted":"2016-08-24T15:37:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-24T20:37:21+00:00","insertUserID":8059,"insertUser":{"userID":8059,"name":"Si Spence","url":"https:\/\/community.smartsheet.com\/profile\/Si%20Spence","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-06\/a7\/2b\/na72b91743286d7fb08a4f7c6508f78dd.png","dateLastActive":"2023-04-12T16:30:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":8059,"lastUser":{"userID":8059,"name":"Si Spence","url":"https:\/\/community.smartsheet.com\/profile\/Si%20Spence","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-06\/a7\/2b\/na72b91743286d7fb08a4f7c6508f78dd.png","dateLastActive":"2023-04-12T16:30:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":459,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/5903\/collaboration-outside-our-organisation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5903\/collaboration-outside-our-organisation","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":391,"urlcode":"product-development","name":"Product Development"}],"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}]},{"discussionID":482,"type":"discussion","name":"Electronic Approval","excerpt":"Have a project tracking sheet that we want to capture customer approval thru Smart Sheet. Would like to have a time stamp and lockdown of the field once they approve so that we have documentation. All we can do right now is send notification thru SS to update the line with approval and get the approval e-mail back and…","categoryID":317,"dateInserted":"2015-06-08T17:05:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-22T15:53:34+00:00","insertUserID":2107,"insertUser":{"userID":2107,"name":"Jeremy Kell","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Kell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-10-16T12:03:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":873,"lastUser":{"userID":873,"name":"Rick Carlisle","url":"https:\/\/community.smartsheet.com\/profile\/Rick%20Carlisle","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/57\/02\/n57025fde3877ef9c23936c51bbf7737b.jpg","dateLastActive":"2020-09-24T16:12:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":34,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/482\/electronic-approval","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/482\/electronic-approval","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":5826,"type":"discussion","name":"Rollup Reporting - Escrow System","excerpt":"I've created a set of templates which are essentially extended to-do lists for tracking real estate escrows. Each new escrow gets a fresh sheet inserted into the work group. The user is responsible for adding the new sheet to the master report. Beyond that, I can't ask uses to create links or other…","categoryID":318,"dateInserted":"2016-08-16T09:24:27+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-17T15:01:14+00:00","insertUserID":3399,"insertUser":{"userID":3399,"name":"Jeremy Myers","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Myers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-23T12:16:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/5826\/rollup-reporting-escrow-system","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5826\/rollup-reporting-escrow-system","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"}],"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}]},{"discussionID":5780,"type":"discussion","name":"Advanced User Training","excerpt":"Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.","categoryID":318,"dateInserted":"2016-08-10T17:51:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-11T10:57:27+00:00","insertUserID":800,"insertUser":{"userID":800,"name":"Archie Lopez","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Archie%20Lopez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-02\/6e\/d9\/n6ed9a535713114243c20137ccc5a4f4c.JPG","dateLastActive":"2023-06-08T15:22:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":234,"lastUser":{"userID":234,"name":"Stephen Branstetter","url":"https:\/\/community.smartsheet.com\/profile\/Stephen%20Branstetter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/18\/9c\/n189cbca1a797d1528b418d7b428974d7.jpg","dateLastActive":"2021-05-10T15:51:58+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5780\/advanced-user-training","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5780\/advanced-user-training","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"},{"tagID":444,"urlcode":"card-view","name":"Card View"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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}]},{"discussionID":5760,"type":"discussion","name":"Problem with Orientation of Attached Photos","excerpt":"Recently our attached photograph files have been displaying only in the landscape\/horizontal orientation when previewed. When we open the attachment it is oriented correctly in the vertical\/portrait orientation. We thought this may be a glitch in the preview feature.","categoryID":318,"dateInserted":"2016-08-09T15:50:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-09T16:50:40+00:00","insertUserID":7859,"insertUser":{"userID":7859,"name":"LeslieW","url":"https:\/\/community.smartsheet.com\/profile\/LeslieW","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp5OrVz4enmh_lCWLmx3MSSwl_A09o7jAT9s-sQq3A=s96-c","dateLastActive":"2023-02-01T21:33:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":7492,"lastUser":{"userID":7492,"name":"Benjamin Walker","url":"https:\/\/community.smartsheet.com\/profile\/Benjamin%20Walker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/1b\/63\/n1b63b1a090b9e3d83ed5a30ad0e05b54.jpg","dateLastActive":"2020-01-27T20:40:59+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/5760\/problem-with-orientation-of-attached-photos","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5760\/problem-with-orientation-of-attached-photos","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":391,"urlcode":"product-development","name":"Product Development"}],"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}]},{"discussionID":5700,"type":"discussion","name":"Conditional Symbols $ to $$$$$","excerpt":"Hi All, I went looking for the below but did not find it, so i built it. Use the below for a 1-5 symbol column like ($-$$$$$) to conditionally set the value based on a column in your list. =IF(Saving1 = MIN(Saving:Saving), \"One\", IF(Saving1 = MAX(Saving:Saving), \"Five\", IF(Saving1 = AVG(Saving:Saving), \"Three\", IF(Saving1…","categoryID":318,"dateInserted":"2016-08-05T00:50:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-05T11:14:44+00:00","insertUserID":4900,"insertUser":{"userID":4900,"name":"Christian Wells","url":"https:\/\/community.smartsheet.com\/profile\/Christian%20Wells","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/cd\/21\/ncd21ac3b27c042921669a4a042840ca4.jpg","dateLastActive":"2021-04-14T05:25:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5700\/conditional-symbols-to","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5700\/conditional-symbols-to","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/community.smartsheet.com\/sites\/all\/libraries\/tinymce\/jscripts\/tiny_mce\/plugins\/emotions\/img\/smiley-smile.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smile"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">