日期更新的一天，但只有当一个框是勾选
答案
-
杰克Gustafson ✭✭✭✭✭✭
看起来您现在有一个列公式填充您的日期。你能不能加入一个额外的参数，如果[Pause SLA]@row = 1，那么[Deadline SLA]@row +1或类似的东西?
0 -
由于奥利奇 ✭
干杯,杰克。我想了想。问题是，它会在日期上增加一天，但不会在暂停时继续增加天数，因为一个问题可能会在等待交付或其他事情时暂停几天，只是增加1不会削减它。另一个问题是，如果你不勾选，它会删除额外的一天。
我已经满足于将SLA更改为当前日期，直到取消暂停，因为SLA将在需要取消暂停之前关闭。唯一会出现问题的情况是，我们可能会在SLA暂停后错过它。尽管如此，如果我取消勾选复选框，它将恢复到原始SLA，这可能会导致问题。
0 -
杰克Gustafson ✭✭✭✭✭✭
好的。我仍然不确定我是否完全明白你的要求，但是这个呢?您可以添加一列来记录启用复选框的日期。然后添加另一列，该列与今天相符，减去复选框日期列，以获得要添加或减去SLA日期的数字。也许您需要另一列表示复选框未选中的日期。我不太确定，但也许你能从我的胡言乱语中找到一些意义。
0
类别
Are you referring to the Resource Management tool you find at the bottom of your workspace list?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-08-24 17:01:46","updateUser":{"userID":147345,"name":"Dennis M Wierzbicki","url":"https:\/\/community.smartsheet.com\/profile\/Dennis%20M%20Wierzbicki","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xAHfcZhNJv8!!SOv7w7J1jdi","dateLastActive":"2022-08-24T18:34:12+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":94603,"type":"question","name":"Formula to change status based on sheet value","excerpt":"I'm trying to change a status (from a dropdown box in sheet summary, based on a date field. When a check box checked the status would change. Sheet Summary Field is \"Construction Status\", drop down list is: Not Started Permitting In Progress Permitted Inventory Slab Starts In Progress Slab Starts Inventory Vertical…","categoryID":321,"dateInserted":"2022-08-24T12:24:29+00:00","dateUpdated":null,"dateLastComment":"2022-08-24T15:00:19+00:00","insertUserID":125814,"insertUser":{"userID":125814,"name":"Jerry Alexander","url":"https:\/\/community.smartsheet.com\/profile\/Jerry%20Alexander","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pqleaeQavDo!XHld3zBOAjw!eGDZYT1_UCj","dateLastActive":"2022-08-24T15:07:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-08-25T08:00:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":33,"score":null,"hot":3322701288,"url":"https:\/\/community.smartsheet.com\/discussion\/94603\/formula-to-change-status-based-on-sheet-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/94603\/formula-to-change-status-based-on-sheet-value","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":94603,"commentID":340921,"name":"Re: Formula to change status based on sheet value","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/340921#Comment_340921","dateInserted":"2022-08-24T15:00:19+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-08-25T08:00:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-24T13:48:31+00:00","dateAnswered":"2022-08-24T13:40:29+00:00","acceptedAnswers":[{"commentID":340902,"body":"
