Report Sorting Assigned To Column

Connor Hartford
Connor Hartford ✭✭✭✭✭
edited 12/09/19 inSmartsheet Basics

Hi,

I had posted another discussion about an issue, but I think I have another issue that might fix my previous issue if I can resolve this current issue. I was having trouble with manipulating tasks and having a view of all resources to be able to manipulate tasks. Here is that post:https://community.smartsheet.com/discussion/resource-allocation-and-manipulation

My current issue is:

I cannot sort a report based on the 'Assigned To' column. I can sort the report based on other columns, but not the 'Assigned To'. In my screenshots below, I show not being able to sort based on 'Assigned To' (pic 1), then I show that I CAN sort based on 'Primary' (pic 2), and then I show that I CAN sort based on 'Start' (pic 3).

Why can I not sort on the 'Assigned To' column?

提前感谢y help.

resource testing picture 1.jpg

resource testing picture 2.jpg

resource testing picture 3.jpg


Connor Hartford

Tags:
· Share on Facebook Share on Twitter

Comments

Categories

Everything will remain as is. They just will no longer be able to access.<\/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":[]},{"discussionID":107734,"type":"question","name":"Summarizing result of a formula","excerpt":"Hello, I have a report that groups and summarizes points earned by individuals - well, it's supposed to do so, but the summary of points doesn't work. This appears to be because the points are calculated by a formula - if I just enter numbers, I can get a sum, but if the number are the result of a formula, the sum = 0.…","snippet":"Hello, I have a report that groups and summarizes points earned by individuals - well, it's supposed to do so, but the summary of points doesn't work. This appears to be because…","categoryID":321,"dateInserted":"2023-07-18T14:42:45+00:00","dateUpdated":null,"dateLastComment":"2023-07-19T14:20:18+00:00","insertUserID":149226,"insertUser":{"userID":149226,"name":"Ldonoghue","url":"https:\/\/community.smartsheet.com\/profile\/Ldonoghue","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!28lBP6L25To!knnAvx7mcjw!0bjLA8JaVC7","dateLastActive":"2023-07-19T18:35:23+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-19T19:26:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":53,"score":null,"hot":3379472583,"url":"https:\/\/community.smartsheet.com\/discussion\/107734\/summarizing-result-of-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107734\/summarizing-result-of-a-formula","format":"Rich","lastPost":{"discussionID":107734,"commentID":385930,"name":"Re: Summarizing result of a formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385930#Comment_385930","dateInserted":"2023-07-19T14:20: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-19T19:26:27+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-19T12:07:36+00:00","dateAnswered":"2023-07-18T15:44:21+00:00","acceptedAnswers":[{"commentID":385758,"body":"

It is fine using a formula as long as the formula is outputting numbers. What formula are you using?<\/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":[]},{"discussionID":107740,"type":"question","name":"Smartsheet ownership","excerpt":"The person who created and \"owns\" an important sheet we need is on 8 weeks maternity leave. We need to change a few things, but no one has that permission. How do we override that?","snippet":"The person who created and \"owns\" an important sheet we need is on 8 weeks maternity leave. We need to change a few things, but no one has that permission. How do we override that?","categoryID":321,"dateInserted":"2023-07-18T15:14:59+00:00","dateUpdated":null,"dateLastComment":"2023-07-18T21:01:34+00:00","insertUserID":76851,"insertUser":{"userID":76851,"name":"Kitty","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kitty","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/6c\/fb\/n6cfbd4e9f8b51ef6eac617de4934460f.jpg","dateLastActive":"2023-07-18T18:11:31+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-19T19:26:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":null,"hot":3379409193,"url":"https:\/\/community.smartsheet.com\/discussion\/107740\/smartsheet-ownership","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107740\/smartsheet-ownership","format":"Rich","lastPost":{"discussionID":107740,"commentID":385833,"name":"Re: Smartsheet ownership","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385833#Comment_385833","dateInserted":"2023-07-18T21:01:34+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-19T19:26:27+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-18T15:52:14+00:00","dateAnswered":"2023-07-18T15:49:34+00:00","acceptedAnswers":[{"commentID":385764,"body":"

If there is anyone shared to the sheet as Admin, they should be able to make the necessary changes or share someone else to the sheet as Admin so that the changes can be made. Otherwise you are just going to have to wait until the owner of the sheet is able to share someone to it as Admin.<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":4855,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • What happens when a user account has been deleted?

    We do a lot of collaborating on our sheets with contractors outside our organization. What happens when that contractor leaves their employment and their company deletes their account? Does all of the data/contributions the contractor did on our sheets remain or do they disappear when their user account is deleted?

  • Summarizing result of a formula

    Hello, I have a report that groups and summarizes points earned by individuals - well, it's supposed to do so, but the summary of points doesn't work. This appears to be because the points are calculated by a formula - if I just enter numbers, I can get a sum, but if the number are the result of a formula, the sum = 0.…

  • Smartsheet ownership

    The person who created and "owns" an important sheet we need is on 8 weeks maternity leave. We need to change a few things, but no one has that permission. How do we override that?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video