请求跟踪表
最好的答案
答案
-
保罗新来的 ✭✭✭✭✭✭
如果双击包含数据的单元格,就像要编辑[估计完成天数]列中的单元格一样,会出现什么?
对于Request ID列,您应该能够删除该列、保存工作表、刷新浏览器,然后重新添加该列。
thinkspi.com
-
只有文本出现在列中(即On Time, 1, 2, -3等)。尝试删除和保存没有列的表单,但仍希望保持编号相同。
-
保罗新来的 ✭✭✭✭✭✭
-
在我看来,没有一个公式存在于任何被锁定的列中。另外两个很简单,但我有一个问题,需要一些工作来解决。
-
保罗新来的 ✭✭✭✭✭✭
-
“预计完成天数”栏中的公式显示,如果请求可以,则“准时”
按所要求的日期完成。如果请求可以提前完成,或者将会延迟完成,您可以
将看到请求将提前(负值)或延迟(正值)的天数。
〇例如,-3表示请求可以在要求的时间前3天完成
日期和(正数)2表示请求的完成将再延迟2天。
-
保罗新来的 ✭✭✭✭✭✭
-
这部分我不太确定。我认为它是与估计完成日期列和所需的列日期(该列不在我的截图)
-
保罗新来的 ✭✭✭✭✭✭
-
她名叫Stara ✭✭✭✭✭✭
你好汉斯,
重置自动号码。
- 将列更改为“文本/数字”
- 删除列中的内容
- 保存
- 刷新工作表
- 将列更改回“自动编号”,并将“起始编号”设置为0
- 保存
公式
试试这样做。
=IF([需要的日期]@row =[预计完成日期]@row;“准时”;[预计完成日期]@row[指定日期]@row)
相同的版本,但有以下更改,以方便您和其他人。
=IF([所需日期]@row =[预计完成日期]@row,“准时”,[预计完成日期]@row[指定日期]@row)
根据国家的不同,你需要把逗号换成句号,把分号换成逗号。
这有用吗?
我希望这对你有帮助!
注意安全,周末愉快!
最好的
她名叫Stara
工作流程顾问/ CEO @工作大胆
✅我的帖子是否帮助或回答了您的问题或解决了您的问题?请帮助社区将其标记为可接受的答案/有用的.这将使其他人更容易找到解决方案或帮助回答!
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
自动号码重置工作得很好!还在试着让函数工作…我得到一个无法解析的错误,我无法解决。
-
她名叫Stara ✭✭✭✭✭✭
@Hans Millican很高兴听到自动号码被破解了。
关于公式。
我很乐意去看看。
你能不能分享一下这些表格/表格的复印件?(在分享之前删除/替换任何机密/敏感信息)这样更容易提供帮助。(分享,(电子邮件保护))
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
-
谢谢分享
-
保罗新来的 ✭✭✭✭✭✭
thinkspi.com
-
她名叫Stara ✭✭✭✭✭✭
@Paul新来的是的,我看单子的时候注意到了。我已经和汉斯分享了正确的版本,所以现在应该可以用了。
智能表专家顾问兼合伙人
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
请随时与我联系,了解有关Smartsheet,集成,一般工作流建议或其他方面的帮助。
帮助文章参考资料欧宝体育app官方888
类别
=COUNTIFS([column4]2:[column4]5,\"Qualification\",[column5]2:[column5]5,\"Q4-2023\")<\/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":[]},{"discussionID":106590,"type":"question","name":"Helper checkbox not working on reference sheet","excerpt":"I have multiple line items for a order in one sheet(Request Sheet) and in another sheet (Order sheet) where I have clubbed all the items in single row, based on the order ID from request sheet to order sheet I want to check the Quantity checkbox and update in the Order sheet, I tried index match formula but its not working…","categoryID":322,"dateInserted":"2023-06-19T11:07:26+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T16:56:49+00:00","insertUserID":153826,"insertUser":{"userID":153826,"name":"Domnic Victor","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Domnic%20Victor","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T15:46:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":144360,"lastUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T22:11:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":36,"score":null,"hot":3374368455,"url":"https:\/\/community.smartsheet.com\/discussion\/106590\/helper-checkbox-not-working-on-reference-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106590\/helper-checkbox-not-working-on-reference-sheet","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106590,"commentID":381185,"name":"Re: Helper checkbox not working on reference sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381185#Comment_381185","dateInserted":"2023-06-19T16:56:49+00:00","insertUserID":144360,"insertUser":{"userID":144360,"name":"Hollie Green","url":"https:\/\/community.smartsheet.com\/profile\/Hollie%20Green","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T22:11: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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TUXJPHZT569J\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T16:01:16+00:00","dateAnswered":"2023-06-19T13:27:24+00:00","acceptedAnswers":[{"commentID":381141,"body":"
The issue is it doesn't know whether to check the box or not check the box because there are multiple ORD0241 on the Request sheet and one is checked and one is not checked. If I am understanding correctly you want the box checked if any of the ORD0241 are checked on the request sheet. If that is correct you would need to use a countifs formula with an If formula<\/p>
=IF(COUNTIFS({Order ID reference from request sheet},[Order ID]@row,{Quantity Helper reference from request sheet},1)>=1,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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106591,"type":"question","name":"Want to flag overlapping dates AND times","excerpt":"Based on information I've found here, I've created a formula that identifies overlapping times that occur on the same day, but I'd like to adapt it to incorporate items that occur over multiple days. This will be used for booking of equipment. Here is what I have so far: =IF(COUNTIFS(SAP:SAP, SAP@row, [Start Date]:[Start…","categoryID":322,"dateInserted":"2023-06-19T12:43:22+00:00","dateUpdated":null,"dateLastComment":"2023-06-19T15:01:21+00:00","insertUserID":162503,"insertUser":{"userID":162503,"name":"Michelle T","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20T","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T15:03:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162503,"lastUser":{"userID":162503,"name":"Michelle T","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20T","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T15:03:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":33,"score":null,"hot":3374367883,"url":"https:\/\/community.smartsheet.com\/discussion\/106591\/want-to-flag-overlapping-dates-and-times","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106591\/want-to-flag-overlapping-dates-and-times","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106591,"commentID":381158,"name":"Re: Want to flag overlapping dates AND times","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381158#Comment_381158","dateInserted":"2023-06-19T15:01:21+00:00","insertUserID":162503,"insertUser":{"userID":162503,"name":"Michelle T","url":"https:\/\/community.smartsheet.com\/profile\/Michelle%20T","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-19T15:03:07+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\/8XNE9V76RH1R\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-19T15:03:04+00:00","dateAnswered":"2023-06-19T14:56:38+00:00","acceptedAnswers":[{"commentID":381157,"body":"
Ok I think I got it. It's due to the times you need to combine the dates and times to get it to consider both as a whole and not individually. So you will need a helper column for your start date\/time and end date time. I titled mine as Start Date Time Helper and End Date Time Helper. If you title them the same you should be able to copy and paste formulas.<\/p>
Start Date Time Helper<\/p>
=IFERROR(VALUE(YEAR(DATEONLY([Start Date]@row)) + \"\" + IF(MONTH(DATEONLY([Start Date]@row)) < 10, \"0\") + MONTH(DATEONLY([Start Date]@row)) + IF(DAY(DATEONLY([Start Date]@row)) < 10, \"0\") + DAY(DATEONLY([Start Date]@row)) + IF([Start Time]@row < 1000, \"0\") + [Start Time]@row), \"\")<\/p>
End Date Time Helper <\/p>
=IFERROR(VALUE(YEAR(DATEONLY([End Date]@row)) + \"\" + IF(MONTH(DATEONLY([End Date]@row)) < 10, \"0\") + MONTH(DATEONLY([End Date]@row)) + IF(DAY(DATEONLY([End Date]@row)) < 10, \"0\") + DAY(DATEONLY([End Date]@row)) + IF([End Time]@row < 1000, \"0\") + [End Time]@row), \"\")<\/p>
Formula to get your Yes\/No's<\/p>
=IF(COUNTIFS(SAP:SAP, SAP@row, [End Date Time Helper]:[End Date Time Helper], @cell >= [Start Date Time Helper]@row, [Start Date Time Helper]:[Start Date Time Helper], @cell <= [End Date Time Helper]@row) > 1, \"No\", \"Yes\")<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">