欢迎来到Smartsheet论坛档案


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

自动刷新数据?

乔恩•布朗＂class=
乔恩•布朗 ✭✭✭✭✭✭
编辑12/09/19 在2017年帖子

我已经开发了一个网页表格，我正在使用从我们的生产线收集生产数据。ob欧宝娱乐app手机下载

然后，我使用smartsheet瞄准镜在我发布的仪表板上显示生产数据。ob欧宝娱乐app手机下载

我可能错了，但是我认为数据发送到的表格需要手动刷新，这样视线才能持续更新?

是否有一种方法可以自动刷新功能?

谢谢

乔恩

标签:
· 在Facebook上分享 在推特上分享
«1

评论

  • 劳拉＂class=
    劳拉 ✭✭✭✭✭✭

    乔恩,

    这正是我最近所做的。(网页表单-生产线-显示ob欧宝娱乐app手机下载屏)

    我安装了一个自动刷新扩展通过谷歌Chrome(或任何你使用)，到目前为止，它似乎工作得很完美!

    · 在Facebook上分享 在推特上分享
  • jcamer25＂class=
    jcamer25 ✭

    劳拉，谢谢你的提示!我还提交了一个增强请求，将此功能添加到Smartsheet。

    增强请求:自动刷新功能

    https://community.smartsheet.com/discussion/enhancement-request-auto-refresh-functionality

    · 在Facebook上分享 在推特上分享
  • 科林Entrekin＂class=
    科林Entrekin ✭✭✭✭✭✭

    是的，这是一个非常恼人的疏忽，我真的很鄙视变通方法;不过，我还是要谢谢你的提示，劳拉。：）＂height=

    Smartsheet，请添加我的投票到这个功能请求。



    如果没有足够智能的表来保持每天(至少)更新，或者更好的是，按预设的时间间隔更新，怎么可能有一个正常运行的仪表板呢?

    · 在Facebook上分享 在推特上分享
  • 斯科特Willeke＂class=
    斯科特Willeke 员工

    我刚刚注意到这个线程，并想指出智能表仪表板现在自动刷新。请参见“配置仪表板自动刷新的频率”https://help.smartsheet.com/articles/2289957-sharing-a-smartsheet-sight

    · 在Facebook上分享 在推特上分享
  • 乔纳森＂class=
    乔纳森

    嗨，斯科特，我知道仪表盘会自动刷新，但是源数据表呢?

    我有网格，从其他工作表和饲料数据到仪表板。这些网格包含无数需要刷新的公式，以便向仪表板提供准确的、最新的信息。

    由于其中一些表是每天早上自动通过电子邮件发送出去的，我如何确保我的源数据表在我没有登录Smartsheet时更新(例如，当我的笔记本电脑关机时)?

    · 在Facebook上分享 在推特上分享
  • cheerfulsri＂class=
    cheerfulsri

    大家好-只是想知道你是否能够找到一个工作区，有自动刷新功能的源数据表。我在触发自动提醒时遇到了一个问题，这是基于公式驱动的“当前日期”列。除非我启用了自动刷新功能，否则我可能不得不考虑其他一些方法。

    感谢您的建议!

    关于

    斯利

    · 在Facebook上分享 在推特上分享
  • 乔纳森＂class=
    乔纳森

    我已经找到了一个解决这个自动刷新问题的方法。

    我用Zapier创建了一个免费帐户，并连接了我的Smartsheet帐户。我创建了一个名为“Refresh”的新工作表，并编程Zapier在每天凌晨3点左右用当前时间和日期戳编辑工作表中的一个单元格。

    接下来，我在每个工作表中创建了一个需要自动刷新的隐藏列，并使用单元格链接从“刷新”工作表中提取时间和日期戳。这样我只有一个zap来从Zapier和细胞链接流数据到所有表我已经链接。由于它正在获得当前的时间和日期戳，Smartsheet认为这是数据正在更改，并将更改保存到表…从而导致刷新。自从做了这个改变后，我每天早上5点自动通过电子邮件发送的报告就有了今天的准确信息，而不是昨天的旧数字。

    我仍然不确定为什么Smartsheet不能在内部处理这类功能。不幸的是，我必须使用第三方(Zapier)来强制刷新。

    我不建议使用浏览器扩展来实现这一点，因为我研究过的许多扩展似乎都带有病毒或间谍软件。

    我希望这对你们中的一些人有所帮助!

    乔纳森

    · 在Facebook上分享 在推特上分享
  • 扎克B＂class=
    扎克B ✭✭✭✭✭✭

    我也有同样的问题。smartsheet是否有任何自动更新源数据表的更新，以便用户无需实际进入表就可以更新公式?

    · 在Facebook上分享 在推特上分享
  • McMinski＂class=
    McMinski

    你好,乔纳森,

    我完全同意你的观点!

    您是否已经提交了产品改进请求?ob欧宝娱乐app手机下载

    · 在Facebook上分享 在推特上分享
  • 肖恩·康纳利＂class=
    肖恩·康纳利 ✭✭✭✭✭✭

    正如用户在下面提到的，如果底层数据没有被自动刷新，这似乎是一种无用的增强。

    · 在Facebook上分享 在推特上分享
  • Munozf＂class=
    Munozf

    2019年我们还没有一个汽车再新鲜的数据吗?

    · 在Facebook上分享 在推特上分享
  • jg124＂class=
    jg124 ✭✭✭✭✭✭

    已尝试此方法，单元格中的时间戳已更新，但表的=TODAY()公式尚未刷新。什么好主意吗?

    · 在Facebook上分享 在推特上分享
  • tc＂class=
    tc ✭✭✭✭✭✭

    我使用了与Jonathan类似的解决方案，利用中央工作表中的单元格链接更新，它涉及到所有其他工作表，并强制刷新这些工作表中的公式。唯一的区别是，我没有使用Zapier击中中央表，而是也把一个今天()公式在一个新列(我然后隐藏)在每个表的中央表馈送日期。然后在中间的工作表上，链接回每个工作表上的TODAY日期字段。这确保了每天一次，无论第一次接触到哪个工作表(中央工作表或任何其他工作表)，单元格链接都会触发并强制更新每个工作表并刷新公式。

    真的想要一些更好的方法来定期刷新表。这一切都是为了确保报告和仪表板拥有准确的信息。

    · 在Facebook上分享 在推特上分享
  • sahar_asis109381＂class=
    sahar_asis109381 ✭✭✭✭✭✭

    嗨，乔纳森，谢谢你发布这个解决方案。

    我只是在Zapier注册，我不完全明白是怎么回事:

    -编程Zapier编辑一个单元格在创建的表格(一个你称为“刷新”)

    -每凌晨3点做一次

    我真的很感谢你在这里的回答，因为我在复杂的表上工作，这个刷新工作是唯一剩下的东西来发布它。

    我的邮件是(电子邮件保护)以防需要一些图片或不允许在这个社区平台上的东西。

    再次感谢你的解决方法，希望你能回答这个问题

    问候

    萨哈尔阿西斯

    ＂

    · 在Facebook上分享 在推特上分享
  • 她名叫Stara＂class=
    她名叫Stara ✭✭✭✭✭✭

    嗨,萨哈尔,

    你解决了吗，还是你还需要帮助?

    祝你有美好的一天!

    最好的

    她名叫Stara

    工作流顾问/ CEO @ WORK BOLD

    work-bold＂data-entity-type=

    Smartsheet专家顾问和合作伙伴

    https://workbold.com/

    她名叫Stara工作流顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    关于Smartsheet、集成、一般工作流建议或其他方面的帮助，请随时与我联系。

    · 在Facebook上分享 在推特上分享
这次讨论已经结束。

类别

=SUM(Select the cells you want to sum)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-23 19:50:46","updateUser":{"userID":155716,"name":"Nkeiruka. Aguocha","url":"https:\/\/community.smartsheet.com\/profile\/Nkeiruka.%20Aguocha","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T22:24:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":99034,"type":"question","name":"Using COUNTIF and CONTAINS","excerpt":"I need to count the number of times a word is found in a cell. My constraint is that the cell can contain multiple words (from a dropdown) and I'm not sure the formula to use. COUNTIF works just fine if the cell only contains one word. I see a report that used both COUNTIFS and CONTAINS but I can't get it to work. The…","categoryID":322,"dateInserted":"2022-12-22T22:51:19+00:00","dateUpdated":null,"dateLastComment":"2022-12-23T00:00:48+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":120231,"lastUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3343504327,"url":"https:\/\/community.smartsheet.com\/discussion\/99034\/using-countif-and-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99034\/using-countif-and-contains","format":"Rich","lastPost":{"discussionID":99034,"commentID":355271,"name":"Re: Using COUNTIF and CONTAINS","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355271#Comment_355271","dateInserted":"2022-12-23T00:00:48+00:00","insertUserID":120231,"insertUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+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":"2022-12-23T00:00:06+00:00","dateAnswered":"2022-12-22T23:30:12+00:00","acceptedAnswers":[{"commentID":355270,"body":"

@Pamela Wagner<\/a> <\/p>

Here's an example sheet and formula I made for someone else's topic once.<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

=COUNTIFS([Teams Responsible for Testing]:[Teams Responsible for Testing], CONTAINS(\"MIS\", @cell), Status:Status, <>\"Complete\")<\/p>

This is used to find \"MIS\" in the Teams Responsible for Testing column if the Status column is not \"Complete\". It's finding 4 results.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-23 00:00:06","updateUser":{"userID":120231,"name":"Pamela Wagner","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Pamela%20Wagner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-22T23:55:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"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":99015,"type":"question","name":"Nested Criteria on COLLECT","excerpt":"I'm trying to get an income by multiplying quantity with Price. Price is located on another sheet so I have to find it based on type, route, and active date. Here's the formula that I have: =IFERROR([Economy QTY]@row * (INDEX(COLLECT({Price Range}; {Type Range}; \"Economy\"; {Route Range}; CONTAINS(Route@row; @cell); {Active…","categoryID":322,"dateInserted":"2022-12-22T09:37:59+00:00","dateUpdated":"2022-12-22T10:15:13+00:00","dateLastComment":"2022-12-23T04:37:44+00:00","insertUserID":156222,"insertUser":{"userID":156222,"name":"Ardneran","url":"https:\/\/community.smartsheet.com\/profile\/Ardneran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T09:42:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":156222,"lastUserID":156222,"lastUser":{"userID":156222,"name":"Ardneran","url":"https:\/\/community.smartsheet.com\/profile\/Ardneran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T09:42:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":42,"score":null,"hot":3343475143,"url":"https:\/\/community.smartsheet.com\/discussion\/99015\/nested-criteria-on-collect","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99015\/nested-criteria-on-collect","format":"Rich","tagIDs":[254,472],"lastPost":{"discussionID":99015,"commentID":355280,"name":"Re: Nested Criteria on COLLECT","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355280#Comment_355280","dateInserted":"2022-12-23T04:37:44+00:00","insertUserID":156222,"insertUser":{"userID":156222,"name":"Ardneran","url":"https:\/\/community.smartsheet.com\/profile\/Ardneran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T09:42:33+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":"2022-12-23T04:37:50+00:00","dateAnswered":"2022-12-23T04:37:44+00:00","acceptedAnswers":[{"commentID":355280,"body":"

Update :<\/p>

I think I figured it out, the formula has two @cells so I think there might be some inconsistency. I changed how my sheet works by modifying some columns so I don't have to use @cell. Thank you all.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-23 04:37:50","updateUser":{"userID":156222,"name":"Ardneran","url":"https:\/\/community.smartsheet.com\/profile\/Ardneran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-23T09:42:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">