未来增强-时间戳

吉恩·H。 · 04/26/23

我想能够创建一个复选框“开始”列，当我检查，当前时间自动输入到不同的列。这与类似的“停止”列相结合，将允许我计算开始/停止之间的差异，并轻松收集完成特定任务所需的平均时间的统计数据。

JennS_ · 05/02/23

这是我现在就可以使用的功能。有人知道当一个表单开始和完成时是否有一个时间戳吗?目前，它看起来只是在将整行添加到工作表或提交表单时添加时间戳。

吉恩·H。 · 05/02/23

@JennS_当我打电话给Smartsheet的代表时，他们说当前可用的时间戳仅适用于创建或修改ROW时。显然，加入社区和投票是未来可能纳入变化的方式。这似乎是一个简单的请求(对我来说很容易说出来)，它会很有帮助。

她名叫Stara · 05/02/23

嗨@Jean H。@JennS_

我希望你一切安好!

这里有一个或多个可能的解决方案

请看看我下面的帖子，我开发了一个方法。

更多信息:

Hi all,<\/p>

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

I've developed a solution that lets you store the date or value.<\/strong><\/p>

You'd use the copy-row automation and a VLOOKUP or combination of INDEX\/MATCH to make it work.<\/p>

We'd trigger the copy-row to another sheet and get the created date\/other value and then use the VLOOKUP\/INDEX\/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id\/value that we can use, it will work.<\/p>

Also, this opens up more options with auto-numbering and similar.<\/p>

Depending on other workflows, you could reuse one sheet for multiple workflows.<\/p>

I hope that helps!<\/p>

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

Stay safe and have a fantastic day!<\/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 all,\\nI hope you're well and safe!\\nI've developed a solution that lets you \"},{\"attributes\":{\"bold\":true},\"insert\":\"store the date or value.\"},{\"insert\":\"\\n\\nYou'd use the copy-row automation and a VLOOKUP or combination of INDEX\\\/MATCH to make it work.\\nWe'd trigger the copy-row to another sheet and get the created date\\\/other value and then use the VLOOKUP\\\/INDEX\\\/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id\\\/value that we can use, it will work.\\n\\nAlso, this opens up more options with auto-numbering and similar.\\nDepending on other workflows, you could reuse one sheet for multiple workflows.\\n\\nI hope that helps!\\nLet me know if you have any questions!\\nStay safe and have a fantastic day!\\nBest,\\n\"},{\"attributes\":{\"bold\":true,\"link\":\"mailto:andree@workbold.com\"},\"insert\":\"Andrée Starå\"},{\"insert\":\" | Workflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/community.smartsheet.com\\\/home\\\/leaving?allowTrusted=1&target=https%3A%2F%2Fworkbold.com%2F\"},\"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":"2020-05-24T11:36:34+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-10T23:30:09+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\/68589\/lock-or-store-date-value-solution-without-using-zapier","embedType":"quote","name":"Lock or Store Date\/Value Solution without using Zapier"}"> https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

这样行吗?

我希望这对你有帮助!

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

最好的

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

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

吉恩·H。 · 05/05/23

她名叫，谢谢。我看过你的其他帖子。我更希望这是Smartsheet的一个简单功能，不需要额外的软件。

登录提交新的想法和投票

未来增强-时间戳

想法提交·最后一次更新04/27/23

评论

类别