小区链路自动刷新

N遗嘱

我有一个表格，显示同事的工作效率，个别同事使用单元格链接，以确保他们只看ob欧宝娱乐app手机下载到自己的信息。

主工作表在跟踪他们的工作时全天自动显示更新，但是他们视图中的链接单元格不会自动刷新，除非刷新整个工作表。有办法解决这个问题吗?

她名叫Stara

嗨@N遗嘱

我希望你一切安好!

请看看我下面的帖子，我开发了一种每天更新表格的方法。

更多信息:

Hi everyone,<\/p>

Happy New Year!<\/p>

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

I've developed a way to use the newly released Record a date <\/strong>feature to update sheets with today's date automatically without the need to open it or similar.<\/p>

1.<\/strong> Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.<\/p>

2.<\/strong> You'd then use an Automation Workflow as described below.<\/p>

Trigger:<\/strong> When a date is reached<\/p>

Every day starting on 2021-01-06 (today or earlier)<\/em><\/p>

02:00 (select the time that makes the most sense for the process)<\/em><\/p>

Conditions<\/strong><\/p>

Where Today Helper<\/strong> is in the past<\/p>

Record a date<\/strong><\/p>

Record a date in Today Helper<\/p>

https:\/\/us.v-cdn.net\/6031209\/uploads\/1R2CO9WEE5M5\/screenshot-of-ghost-browser-282021-01-06-2c-14-22-21-29.jpg<\/a><\/p>

This could also be structured so you'd use a so-called helper sheet for the process above and then link it to all other sheets where you'd need the daily update.<\/em><\/p>

Let me know if you have any questions!<\/p>

I hope that helps!<\/p>

Stay safe, and Happy New Year!<\/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 help the Community by <\/em>marking it as helpful<\/em><\/strong>. It will make it easier for others to find a solution.<\/em><\/p>","bodyRaw":"[{\"insert\":\"Hi everyone,\\nHappy New Year!\\nI hope you're well and safe!\\nI've developed a way to use the newly released \"},{\"attributes\":{\"bold\":true},\"insert\":\"Record a date \"},{\"insert\":\"feature to update sheets with today's date automatically without the need to open it or similar.\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"1.\"},{\"insert\":\" Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"2.\"},{\"insert\":\" You'd then use an Automation Workflow as described below.\\n\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Trigger:\"},{\"insert\":\" When a date is reached\\nEvery day starting on 2021-01-06 \"},{\"attributes\":{\"italic\":true},\"insert\":\"(today or earlier)\"},{\"insert\":\"\\n02:00 \"},{\"attributes\":{\"italic\":true},\"insert\":\"(select the time that makes the most sense for the process)\"},{\"insert\":\"\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Conditions\"},{\"insert\":\"\\nWhere\"},{\"attributes\":{\"bold\":true},\"insert\":\" Today Helper\"},{\"insert\":\" is in the past\\n\"},{\"attributes\":{\"bold\":true},\"insert\":\"Record a date\"},{\"insert\":\"\\nRecord a date in Today Helper\\n\\n\"},{\"insert\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/1R2CO9WEE5M5\\\/screenshot-of-ghost-browser-282021-01-06-2c-14-22-21-29.jpg\",\"attributes\":{\"link\":\"https:\\\/\\\/us.v-cdn.net\\\/6031209\\\/uploads\\\/1R2CO9WEE5M5\\\/screenshot-of-ghost-browser-282021-01-06-2c-14-22-21-29.jpg\"}},{\"insert\":\"\\n\"},{\"insert\":\"\\n\"},{\"attributes\":{\"italic\":true},\"insert\":\"This could also be structured so you'd use a so-called helper sheet for the process above and then link it to all other sheets where you'd need the daily update.\"},{\"insert\":\"\\n\\nLet me know if you have any questions!\\n I hope that helps!\\nStay safe, and Happy New Year!\\nBest,\\n\"},{\"attributes\":{\"bold\":true,\"link\":\"mailto:andree@workbold.com\"},\"insert\":\"Andrée Starå\"},{\"insert\":\" | Workflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/workbold.com\\\/\"},\"insert\":\"WORK BOLD\"},{\"insert\":\"\\n✅\"},{\"attributes\":{\"italic\":true},\"insert\":\"Did my post(s) help or answer your question or solve your problem? Please help the Community by \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"marking it as helpful\"},{\"attributes\":{\"italic\":true},\"insert\":\". It will make it easier for others to find a solution.\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2021-01-06T13:40:12+00:00","insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-04T20:59:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":true,"showPostLink":true,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/74527\/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar","embedType":"quote","name":"Daily Update Solution without the need to open the sheet, use Zapier, or similar"}"> https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

那有用吗?

我希望这对你有帮助!

注意安全，祝你一周愉快!

最好的

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

✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为“有见地”/“投票赞成”、“很棒”或“并且”作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!

N遗嘱

我希望找到一种方法，可以在他们完成工作时全天更新，这样他们就可以看到更多的实时完成状态，而不必手动刷新页面。没什么大不了的，但有点奇怪的是，其他方法，如公式将更新更多的实时，但单元格链接没有。

她名叫Stara

@N遗嘱

你可以每小时加一个。

这样行吗?

✅记住!我的帖子是否帮助或回答了你的问题或解决了你的问题?请支持社区将其标记为有洞察力/投票赞成/很棒或/和作为公认的答案。这将使其他人更容易找到解决方案或帮助回答!