欢迎来到Smartsheet论坛档案


在这个论坛的帖子不再被监控的准确性和他们的内容可能不再是最新的。如果这里有你感兴趣的讨论,你想找到(或创建)一个更最新的版本,请访问当前论坛。

地图应用问题

我想用地图App完成两件事,

1)我第一次这样做的时候,我在RH栏上得到了一个单独的属性列表,所以我可以勾选/取消勾选我想要在地图上显示的地址,现在它消失了,我不知道如何把它找回来。只有一个总#和选择所有选项。

2)这是给测量公司的,我们可以根据指定的现场人员对位置进行颜色标记吗?报告中有一个下拉选项可以选择分配给谁的地址,每个分配人员的地址是否可以用不同的颜色编码?我知道这应该与分组有关,但我不明白。

非常感谢!

标签:

评论

  • 斯蒂芬妮·泰勒
    斯蒂芬妮·泰勒 ✭✭✭✭✭✭

    问题2的答案-你需要在你的智能表上有一个列,每个地址都有分配的字段人,然后当你在构建地图时,在分组列中选择“分配的字段人”。然后,地图上的地址将由他们指定的人员进行颜色编码。

  • 特拉维斯
    特拉维斯 员工
    编辑07/06/15

    Jody,没有办法只选择要包含在地图中的某些行。你可能会想到“group by”功能,它并不意味着显示/隐藏单个位置,但如果它指向每个位置具有唯一信息的列,则可以用于此。

  • 特拉维斯,假设我选了一张有25个地址的单子。应用程序是否可以列出地址,以便我可以选择哪些地址(例如:25个中的10个),我想通过复选框在地图上显示,或者我必须在将它们插入地图应用程序之前对它们进行预过滤?

这次讨论已经结束了。
[Date of Site Survey (Product)]@row, \"yes\", \" \")) Intended logic\/result - If date cell is blank, then \"blank\" (this worked when I tried without the 2nd argument added) If date is in…","categoryID":322,"dateInserted":"2023-06-09T14:00:25+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:29:50+00:00","insertUserID":162220,"insertUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:55:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162220,"lastUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:55:02+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3372641415,"url":"https:\/\/community.smartsheet.com\/discussion\/106265\/if-date-is-blank-past-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106265\/if-date-is-blank-past-formula","format":"Rich","lastPost":{"discussionID":106265,"commentID":379837,"name":"Re: If Date is blank + past formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379837#Comment_379837","dateInserted":"2023-06-09T14:29:50+00:00","insertUserID":162220,"insertUser":{"userID":162220,"name":"dhawkins","title":"Product Manager","url":"https:\/\/community.smartsheet.com\/profile\/dhawkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:55:02+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T14:28:35+00:00","dateAnswered":"2023-06-09T14:12:11+00:00","acceptedAnswers":[{"commentID":379830,"body":"

Try this:<\/p>

=IF([Date of Site Survey (Product)]@row <> \"//www.santa-greenland.com/community/discussion/1080/\", IF(TODAY() > [Date of Site Survey (Product)]@row, \"yes\", \"no\"))<\/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":106250,"type":"question","name":"Group & User Management - Sorting of Members","excerpt":"Hi I have 2 questions regarding Group Management... Does anyone know if it's possible to sort the Members alphabetically please? Even though they were imported in alphabetical order, when I open the group the list is randomly sorted. Not helpful when you're trying to search for a user within a list of 100 people. Is there…","categoryID":321,"dateInserted":"2023-06-09T05:36:26+00:00","dateUpdated":"2023-06-09T07:56:35+00:00","dateLastComment":"2023-06-09T12:50:31+00:00","insertUserID":162237,"insertUser":{"userID":162237,"name":"L Darvesh","title":"Traffic Manager","url":"https:\/\/community.smartsheet.com\/profile\/L%20Darvesh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZkq45uc1ao!0kMp_wPZcXo!pVSqynctQ0w","dateLastActive":"2023-06-09T12:47:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162237,"lastUser":{"userID":162237,"name":"L Darvesh","title":"Traffic Manager","url":"https:\/\/community.smartsheet.com\/profile\/L%20Darvesh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZkq45uc1ao!0kMp_wPZcXo!pVSqynctQ0w","dateLastActive":"2023-06-09T12:47:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3372605217,"url":"https:\/\/community.smartsheet.com\/discussion\/106250\/group-user-management-sorting-of-members","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106250\/group-user-management-sorting-of-members","format":"Rich","tagIDs":[442],"lastPost":{"discussionID":106250,"commentID":379805,"name":"Re: Group & User Management - Sorting of Members","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379805#Comment_379805","dateInserted":"2023-06-09T12:50:31+00:00","insertUserID":162237,"insertUser":{"userID":162237,"name":"L Darvesh","title":"Traffic Manager","url":"https:\/\/community.smartsheet.com\/profile\/L%20Darvesh","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!jZkq45uc1ao!0kMp_wPZcXo!pVSqynctQ0w","dateLastActive":"2023-06-09T12:47:42+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-09T12:50:00+00:00","dateAnswered":"2023-06-09T11:29:41+00:00","acceptedAnswers":[{"commentID":379791,"body":"

HI @L Darvesh<\/a> <\/p>

  1. Currently there is no sorting inside of a group. Please vote for that functionality in this Enhancement Request:<\/li><\/ol>
    \n \n https:\/\/community.smartsheet.com\/discussion\/104139\/group-management-sorting-contact-list-alphabetically\n <\/a>\n<\/div>\n
    1. To my knowledge this is not available. As a System Admin on Enterprise Plan, I can export the User List and sort\/filter that way but it would be nice to be able to do this inside of Smartsheet. From Plan & Billing\/User Management I can filter but it does not count.<\/li><\/ol>"}]}},"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":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"}]},{"discussionID":106244,"type":"question","name":"Multi-part formula with multi select field using references issue","excerpt":"Hello- I am trying to write a formula that includes sheet references, and two conditions. I need to count the number of students in each category and how many of those students chose a specific availability time from a multi-select drop-down menu. This is what I came up with but doesn't work. =COUNTIFS({Student Type},…","categoryID":322,"dateInserted":"2023-06-08T21:31:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:55:22+00:00","insertUserID":125320,"insertUser":{"userID":125320,"name":"Kimberly Slavsky","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Slavsky","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:59:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":125320,"lastUser":{"userID":125320,"name":"Kimberly Slavsky","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Slavsky","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:59:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3372583602,"url":"https:\/\/community.smartsheet.com\/discussion\/106244\/multi-part-formula-with-multi-select-field-using-references-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106244\/multi-part-formula-with-multi-select-field-using-references-issue","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106244,"commentID":379845,"name":"Re: Multi-part formula with multi select field using references issue","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379845#Comment_379845","dateInserted":"2023-06-09T14:55:22+00:00","insertUserID":125320,"insertUser":{"userID":125320,"name":"Kimberly Slavsky","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Slavsky","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:59:34+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T14:55:06+00:00","dateAnswered":"2023-06-09T05:19:35+00:00","acceptedAnswers":[{"commentID":379763,"body":"

      Hi Kimberly, try this.<\/p>

      =COUNTIFS({Student Type}, \"University Student\", {Student Availability}, HAS(@cell, \"Monday AM\"))<\/p>

      --Anson<\/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":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

      热门文章