创建日期公式的形式
是否有一个公式可以捕获表单上新条目的创建日期?表单完成后，我希望有一列能够自动填充从表单中添加行的日期，以便跟踪响应时间。除了审计日志之外，还有其他可用的东西吗?
评论
-
J.克雷格·威廉姆斯 ✭✭✭✭✭如果没有“[已创建]系统”列，请添加。
然后
(电子邮件保护)”+“
将显示整个日期/时间戳。注意，这是TEXT而不是日期/时间。您需要解析时间以确定数字响应时间。
和
，将返回日期(作为日期)
我希望这对你有帮助。
克雷格
-
正是我需要的-谢谢!
日内瓦 -
J.克雷格·威廉姆斯 ✭✭✭✭✭
我很高兴。
克雷格
-
Jairo戈麦斯 ✭转换为日期格式:= date (VALUE("20" + RIGHT(LEFT(Created1, 8)， 2))， VALUE(LEFT(Created1, 2))， VALUE(RIGHT(LEFT(Created1, 5)， 2))))
帮助文章参考资料欧宝体育app官方888
类别
=IF(AND([Budget Forecast]@row>= 0.90, [Budget Forecast]@row<= 1), \"Green\", IF(AND<\/strong>([Budget Forecast]@row>= 0.80, [Budget Forecast]@row<= 1.03), \"Yellow\", \"Red\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-22 08:34:56","updateUser":{"userID":124479,"name":"Helen Coen","url":"https:\/\/community.smartsheet.com\/profile\/Helen%20Coen","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xRDV8etL72Q!AdtVgBN2zjw!JHhi1z5cfgR","dateLastActive":"2022-12-22T08:33:19+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":98998,"type":"question","name":"Using result from one check box to check another box","excerpt":"The trigger box is a checkmark, the receiving box is a star. I'm using this formula: =IF ([ShipC Updated]@row = 1), 1 The column name is ShipC Updated, the column I'm putting the formula in is Complete (has the star). I'm getting #Unparsable errors regardless of what I try! Please help!! Snip of spreadsheet below. Both…","categoryID":322,"dateInserted":"2022-12-21T18:39:51+00:00","dateUpdated":null,"dateLastComment":"2022-12-21T20:15:00+00:00","insertUserID":156200,"insertUser":{"userID":156200,"name":"ReneeW","url":"https:\/\/community.smartsheet.com\/profile\/ReneeW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-21T20:54:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":156200,"lastUser":{"userID":156200,"name":"ReneeW","url":"https:\/\/community.smartsheet.com\/profile\/ReneeW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-21T20:54:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":43,"score":null,"hot":3343306491,"url":"https:\/\/community.smartsheet.com\/discussion\/98998\/using-result-from-one-check-box-to-check-another-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98998\/using-result-from-one-check-box-to-check-another-box","format":"Rich","lastPost":{"discussionID":98998,"commentID":355147,"name":"Re: Using result from one check box to check another box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355147#Comment_355147","dateInserted":"2022-12-21T20:15:00+00:00","insertUserID":156200,"insertUser":{"userID":156200,"name":"ReneeW","url":"https:\/\/community.smartsheet.com\/profile\/ReneeW","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-21T20:54:14+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/R9AMERP2LMMH\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-21T19:45:29+00:00","dateAnswered":"2022-12-21T18:58:49+00:00","acceptedAnswers":[{"commentID":355126,"body":" Hi @ReneeW<\/a> <\/p> I hope you're well and safe!<\/p> Try something like this.<\/p> =IF([ShipC Updated]@row = 1, 1)<\/p> Did that work\/help? <\/p> I hope that helps!<\/p> Have a fantastic week & Happy Holidays!<\/p> Best,<\/p> Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>
