开始日期/提醒某人
我知道我想得太多了，但我正试图弄清楚2周的情况。
假设开始日期为7/20/21，我希望Smartsheet在两周前给我一个提醒。在Smartsheet中正确的设置是什么?
答案
-
保罗新来的 ✭✭✭✭✭✭尝试将其设置为基于日期字段运行，然后将条件设置为该日期字段在未来14天内的时间。
如果这不起作用，我通常插入一个日期列，然后使用一个公式填充我希望自动化运行的日期，然后根据这个新的日期列将其设置为触发。在你的情况下，公式是
=[开始日期]- 14
thinkspi.com
-
雷·桑切斯 ✭
在触发器中，我应该把它写在“两周前”吗?另外，我在条件中设置了什么?
-
保罗新来的 ✭✭✭✭✭✭
-
雷·桑切斯 ✭
我相信我是对的。
-
保罗新来的 ✭✭✭✭✭✭
-
雷·桑切斯 ✭
是的。它一直在起作用。谢谢你！
-
保罗新来的 ✭✭✭✭✭✭
类别
You cannot reference specific cells in the conditional format in a manner that would make this easy. You cannot, for instance, say IF this specific cell is greater than that cell, apply this format. You can do it for the same row, but not always referencing the same cell. We get around this by inserting a \"helper\" column for each condition we want to check. The checkbox format works great. In the conditional format rule, you can simply say IF THIS cell is checked, apply the format to THAT cell. <\/p>
To set the checkbox to checked\/unchecked, we use this column formula: =IF(PDP@row > PDP#, 1, 0)<\/p>
But what is PDP#? This is another issue we have to work around. You cannot reference the first cell of a column in a column formula, you can only reference cells in the same row. To work around this, we add fields into the sheet summary. [PDP]# references the PDP field in the sheet summary. In order to make updating these values easier, we set the value of this field equal to the first cell in the PDP column using =PDP1<\/p>
After creating all of the helper columns, setting up the column formulas for each to determine which ones are checked, creating all of the necessary fields in the sheet summary, and setting those equal to the first cells in each of the respective columns within the sheet, we can set up the conditional formatting.<\/p>
Check out the image below to get an idea of how to setup the formats. Unfortunately, we have one more workaround to setup at this stage. Since the formatting will apply to every row in the sheet, it will apply to the first row as well and all of those cells will be green. To get around this, add the first format pictured below as the first one in your list. For the background color, you must select \"white\" in order to avoid the highlight. If you set it to \"no background\", you will get an error because Smartsheet does not see \"no background\" as a format.<\/p>
After everything is setup and running, you should be able to update the cells in your target row and things will work themselves out automatically.<\/p>
<\/p>
<\/p>
![\"Condition.PNG\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/OSQDONLE4GNE\/condition-png.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nI hope this helps, and I really hope it makes sense.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]},{"discussionID":106723,"type":"question","name":"Is there a way to arrange data in a Metric Widget?","excerpt":"On my Dashboard, I have 3 metric widgets displaying metrics from 3 different departments via summary data from a sheet. 1 of the 3 widgets displays the information in an ABCD order while the other 2 display it in a DABC order. How can I reorder the data so that it is consistent and in the order I want? I would not think…","categoryID":321,"dateInserted":"2023-06-21T19:10:27+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T12:16:17+00:00","insertUserID":159618,"insertUser":{"userID":159618,"name":"SASardy","url":"https:\/\/community.smartsheet.com\/profile\/SASardy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A4Dfn6qyguQ!pEjeKe7HqSY!L0au68m3r5x","dateLastActive":"2023-06-21T20:01:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-22T13:13:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"score":null,"hot":3374812604,"url":"https:\/\/community.smartsheet.com\/discussion\/106723\/is-there-a-way-to-arrange-data-in-a-metric-widget","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106723\/is-there-a-way-to-arrange-data-in-a-metric-widget","format":"Rich","tagIDs":[292],"lastPost":{"discussionID":106723,"commentID":381705,"name":"Re: Is there a way to arrange data in a Metric Widget?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381705#Comment_381705","dateInserted":"2023-06-22T12:16:17+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-22T13:13:45+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":"2023-06-21T20:03:34+00:00","dateAnswered":"2023-06-21T19:42:26+00:00","acceptedAnswers":[{"commentID":381604,"body":"
If you hover over the data point, you should be able to grab the button on the right and click and drag it up and down.<\/p>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/IEPF8MV8BTLQ\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]},{"discussionID":106725,"type":"question","name":"Start\/stop buttons for timekeeping?","excerpt":"Hello! I am curious to know if anyone has a solution for stop\/start buttons to record team members' time toward projects in Smartsheet outside of Resource Management. This is for a small team without access to any premium apps. When a new project is set up, it is added to a master Project List sheet, and manually added to…","categoryID":343,"dateInserted":"2023-06-21T19:22:38+00:00","dateUpdated":"2023-06-21T19:27:04+00:00","dateLastComment":"2023-06-22T09:15:46+00:00","insertUserID":126351,"insertUser":{"userID":126351,"name":"Julie Fortney","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Julie%20Fortney","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hZje4WgcMyQ!en9eZ1QFHfo!MFtz_rjuwYj","dateLastActive":"2023-06-22T13:13:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"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-22T15:05:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":36,"score":null,"hot":3374804904,"url":"https:\/\/community.smartsheet.com\/discussion\/106725\/start-stop-buttons-for-timekeeping","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106725\/start-stop-buttons-for-timekeeping","format":"Rich","tagIDs":[468,553],"lastPost":{"discussionID":106725,"commentID":381687,"name":"Re: Start\/stop buttons for timekeeping?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381687#Comment_381687","dateInserted":"2023-06-22T09:15:46+00:00","insertUserID":8888,"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-22T15:05:35+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T21:40:12+00:00","dateAnswered":"2023-06-21T21:18:20+00:00","acceptedAnswers":[{"commentID":381638,"body":"
