Archived 2017 Posts

=IFERROR(<\/strong>INDEX({Updates}, MATCH([Auto number]@row, {Auto Number}, 0)), \"//www.santa-greenland.com/community/categories/c2017/\")<\/strong><\/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":107451,"type":"question","name":"Formula for Symbols","excerpt":"Hello! hope this is easy enough but im still trying to master my formulas with symbols. Can anyone help me with this one? I need to use the symbol to indicate if current month is more, less or same as prior month @row","snippet":"Hello! hope this is easy enough but im still trying to master my formulas with symbols. Can anyone help me with this one? I need to use the symbol to indicate if current month is…","categoryID":322,"dateInserted":"2023-07-11T16:05:07+00:00","dateUpdated":null,"dateLastComment":"2023-07-11T18:04:18+00:00","insertUserID":146602,"insertUser":{"userID":146602,"name":"ldavenportHAP","url":"https:\/\/community.smartsheet.com\/profile\/ldavenportHAP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-11T19:18:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-11T19:04:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":41,"score":null,"hot":3378191965,"url":"https:\/\/community.smartsheet.com\/discussion\/107451\/formula-for-symbols","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107451\/formula-for-symbols","format":"Rich","lastPost":{"discussionID":107451,"commentID":384657,"name":"Re: Formula for Symbols","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384657#Comment_384657","dateInserted":"2023-07-11T18:04:18+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-07-11T19:04:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"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\/8MI9TMLH9T8J\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-11T16:47:57+00:00","dateAnswered":"2023-07-11T16:32:51+00:00","acceptedAnswers":[{"commentID":384626,"body":"

You would use a nested IF statement.<\/p>

=IF([AR Days Current Month]@row>[AR Days Prior Month]@row, \"up arrow\", IF([AR Days Current Month]@row<[AR Days Prior Month]@row, \"down arrow\", \"right arrow\"))<\/p>

<\/p>

You will need to replace each \"directional arrow\" with the appropriate text value. You can find out what text values to use by clicking on one of the cells in the symbol column and expanding the options as if you are going to manually select them.<\/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":107449,"type":"question","name":"A formula to calculate 10% of the Approved Budget","excerpt":"Hi I need help creating a formula to calculate 10% of the Approved Budget. Kind regards Marcy","snippet":"Hi I need help creating a formula to calculate 10% of the Approved Budget. Kind regards Marcy","categoryID":322,"dateInserted":"2023-07-11T15:59:51+00:00","dateUpdated":null,"dateLastComment":"2023-07-11T16:06:51+00:00","insertUserID":124101,"insertUser":{"userID":124101,"name":"Marcy Morris","url":"https:\/\/community.smartsheet.com\/profile\/Marcy%20Morris","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Dz9dQ1L6w_w!2mDRP2igUmQ!B-8HC7uSYxG","dateLastActive":"2023-07-11T16:07:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":124101,"lastUser":{"userID":124101,"name":"Marcy Morris","url":"https:\/\/community.smartsheet.com\/profile\/Marcy%20Morris","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Dz9dQ1L6w_w!2mDRP2igUmQ!B-8HC7uSYxG","dateLastActive":"2023-07-11T16:07:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3378184002,"url":"https:\/\/community.smartsheet.com\/discussion\/107449\/a-formula-to-calculate-10-of-the-approved-budget","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107449\/a-formula-to-calculate-10-of-the-approved-budget","format":"Rich","lastPost":{"discussionID":107449,"commentID":384614,"name":"Re: A formula to calculate 10% of the Approved Budget","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384614#Comment_384614","dateInserted":"2023-07-11T16:06:51+00:00","insertUserID":124101,"insertUser":{"userID":124101,"name":"Marcy Morris","url":"https:\/\/community.smartsheet.com\/profile\/Marcy%20Morris","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Dz9dQ1L6w_w!2mDRP2igUmQ!B-8HC7uSYxG","dateLastActive":"2023-07-11T16:07:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-11T16:07:11+00:00","dateAnswered":"2023-07-11T16:03:39+00:00","acceptedAnswers":[{"commentID":384612,"body":"

Hi @Marcy Morris<\/a> <\/p>

I hope you're well and safe!<\/p>

Try something like this.<\/p>

=0.1 * [Approved Budget]@row<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">