欢迎来到Smartsheet论坛档案


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

同步到Google Drive

尼克Tsotras
尼克Tsotras ✭
编辑12/09/19 在2015年发布的文章

如何从Smartsheet同步到Google Drive文件夹/文件

标签:
· 在Facebook上分享 在Twitter上分享

评论

这次讨论已经结束了。

类别

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":106239,"type":"question","name":"Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","excerpt":"I spent the last month building a solution for people to sign up for mentors by creating a sheet that has information about each mentor and lots of formulas color fields where someone has already signed up with only a max number of sign up fields (aka I can't do this in forms that I know of). I created a Dynamic View with…","categoryID":343,"dateInserted":"2023-06-08T20:54:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":160816,"lastUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":20,"score":null,"hot":3372578665,"url":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login","format":"Rich","tagIDs":[223,443],"lastPost":{"discussionID":106239,"commentID":379829,"name":"Re: Help! Published a Sheet with Edit by Anyone Permissions but Dynamic View is Requiring a Login","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379829#Comment_379829","dateInserted":"2023-06-09T14:09:40+00:00","insertUserID":160816,"insertUser":{"userID":160816,"name":"Sara H","url":"https:\/\/community.smartsheet.com\/profile\/Sara%20H","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!26_eP3rAZ3w!3LFcf_LcDHw!n_D8wzNBgmE","dateLastActive":"2023-06-09T14:12:11+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-09T14:07:07+00:00","dateAnswered":"2023-06-08T23:09:15+00:00","acceptedAnswers":[{"commentID":379755,"body":"
      \n \n https:\/\/community.smartsheet.com\/discussion\/106239\/help-published-a-sheet-with-edit-by-anyone-permissions-but-dynamic-view-is-requiring-a-login\n <\/a>\n<\/div>\n

      Hi Sara!<\/p>

      Dynamic View has its own settings for sharing that are separate from those on your underlying published sheet. If you haven't already shared the DV, itself (as well as the source sheet<\/em>), I think that may be the roadblock here. <\/p>

      When you open the settings for your DV, you'll see \"Sharing<\/strong>\" on the far right. I chose the Shared domains option at the bottom to ensure users enterprise-wide could access a particular DV I created, even if they didn't have a Smartsheet account. Adding the appropriate domain(s) (i.e., the part of your email address after the @<\/strong>; like CompanyXYZ<\/em>.com<\/em>) for your user audience should clear up the restrictions requiring sign-in.<\/p>

      If sharing at the domain level is too broad, I would suggest creating a named Group within the Smartsheet Admin Center (\"Group Management<\/em>\"). You can copy a list of email addresses and paste them into the \"Add Members\" field to \"bulk load\" a large group of users. Once your group is created, use the dropdown in the Shared groups option to select the appropriate group.<\/p>

      \n
      \n \n \"DV<\/img><\/a>\n <\/div>\n<\/div>\n

      I hope this helps resolve your problem! Please let me know how it goes!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":223,"urlcode":"Publish","name":"Publish"},{"tagID":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":106232,"type":"question","name":"Check if project start\/end dates fall within specific time frame.","excerpt":"My team works on projects that typically take 6-12 months. I'd like to create a roll-up sheet that identifies which quarters in which a project was worked on. I'm creating a new row for each project and linking in the start and end dates from each of the projects' sheets. Then I've created a new column for each quarter…","categoryID":322,"dateInserted":"2023-06-08T19:44:47+00:00","dateUpdated":"2023-06-08T22:03:24+00:00","dateLastComment":"2023-06-09T14:05:37+00:00","insertUserID":161563,"insertUser":{"userID":161563,"name":"gunnell","title":"Director, eLearning Initiatives","url":"https:\/\/community.smartsheet.com\/profile\/gunnell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:01:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161563,"lastUserID":161563,"lastUser":{"userID":161563,"name":"gunnell","title":"Director, eLearning Initiatives","url":"https:\/\/community.smartsheet.com\/profile\/gunnell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:01:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3372574224,"url":"https:\/\/community.smartsheet.com\/discussion\/106232\/check-if-project-start-end-dates-fall-within-specific-time-frame","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106232\/check-if-project-start-end-dates-fall-within-specific-time-frame","format":"Rich","lastPost":{"discussionID":106232,"commentID":379826,"name":"Re: Check if project start\/end dates fall within specific time frame.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379826#Comment_379826","dateInserted":"2023-06-09T14:05:37+00:00","insertUserID":161563,"insertUser":{"userID":161563,"name":"gunnell","title":"Director, eLearning Initiatives","url":"https:\/\/community.smartsheet.com\/profile\/gunnell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:01:37+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:05:51+00:00","dateAnswered":"2023-06-09T14:05:37+00:00","acceptedAnswers":[{"commentID":379826,"body":"

      \n \n https:\/\/community.smartsheet.com\/discussion\/comment\/379822#Comment_379822\n <\/a>\n<\/div>\n

      The problem I was having with something similar to what you have is that it wasn't picking up projects that started before the quarter and ended after the quarter. So if project started in 2022Q4, continued in 2023Q1, and ended during 2023Q2, I would want a \"1\" for all three quarters but it was only giving me one for 2022Q4 and 2023Q2 (skipping 2023Q1).<\/p>

      I actually just got this working late last night (with the help of ChatGPT). Here is what I ended up with. This one checks for 2022Q1.<\/p>

      =IF(OR(AND($Start@row <= DATE(2022, 3, 31), $End@row >= DATE(2022, 1, 1)), AND(DATE(2022, 1, 1) <= $End@row, DATE(2022, 3, 31) >= $Start@row)), 1, 0)<\/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":[]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

      热门文章

      • 组和用户管理-排序的成员

        嗨，我有两个关于集团管理的问题…有人知道能不能按字母顺序排序吗?尽管它们是按字母顺序导入的，但当我打开组时，列表是随机排序的。当您试图在100人的列表中搜索用户时，这是没有帮助的。有……

      • 的帮助!发布了任何人都可以编辑的工作表，但是动态视图需要登录

        上个月我花了一个月的时间为人们建立一个注册导师的解决方案，通过创建一个表格，其中包含每个导师的信息和许多公式颜色字段，其中有人已经注册，只有最大数量的注册字段(也就是说，我不能在我所知道的表格中这样做)。我创建了一个动态视图。

      • 检查项目的开始/结束日期是否在特定的时间范围内。

        我的团队通常需要6-12个月才能完成项目。我想创建一个汇总表，以确定项目在哪个季度进行。我正在为每个项目创建一个新行，并从每个项目的表中链接开始和结束日期。然后我为每个季度创建了一个新专栏……