如果今天是星期一，打勾

MCastillo
MCastillo ✭
编辑12/09/19 在公式和函数

我有一个[截止日期]栏和一个[星期一]复选框栏。我正在尝试创建一个公式，可以在星期一的任何[截止日期]上勾选框。

我只得打开方框检查今天是不是星期一:

= if(平日(今天))= 2,1,0)

但我想不出其他的。

谢谢你的帮助!

标签:
· 在Facebook上分享 在Twitter上分享

评论

  • 安德鲁•斯图尔特
    安德鲁•斯图尔特 ✭✭

    你已经做了艰苦的工作，只需将TODAY()替换为[Due By]@row

    =如果(工作日([在]@row)= 2, 1, 0)

    · 在Facebook上分享 在Twitter上分享
  • MCastillo
    MCastillo ✭
    编辑02/11/19

    天才!谢谢你，安德鲁!

    我是新手。

    我想做的另一件与此相关的事情是让Smartsheet在周一早上给我发一个提醒，告诉我本周所有的截止日期，包括周一。但我不明白。

    我在想，这可能与更改公式有关，所以这个框是未选中的，只有在周一到来时才会检查。然后警报可以是“当添加或更改一行时，当Monday变为Checked…”然而，我不知道如何完成提醒，以确保它发送我所有的事情，这周到期。： （

    对此有什么想法吗?

    · 在Facebook上分享 在Twitter上分享
  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    你好,

    我建议设置一个报告，让它在每周一自动发送，或者任何有意义的事情。

    这样行吗?

    祝你一周愉快!

    最好的

    她名叫Stara

    工作流程顾问@完成咨询

    智能表专家顾问兼合伙人

    https://workbold.com/

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

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。

    · 在Facebook上分享 在Twitter上分享

帮助文章参考资料欧宝体育app官方888

在智能表中创建和编辑公式

交叉表引用的公式组合

智能表功能列表

类别

想要直接在智能表中练习使用公式吗?

请查看公式手册模板!
Hi @mragans23<\/a>,<\/p>

In Smartsheet you'd need to add @row to the GLAcct portion of your the formula. <\/p>

For example, the first section would be:<\/p>

=IF(OR(GLAcct@row = \"710111\", GLAcct@row = \"710121\"), \"Key Salary\")<\/p>

Once you've entered it for one row, you can then right click the cell and \"Convert to Column Formula\" to have it applied to all rows in the column. <\/p>

Other than that, I think everything should be OK once you add the @row in.<\/p>

Hope that helps; any questions etc. then just post! 😊<\/span><\/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":106682,"type":"question","name":"Make sum of one column in function of value of another","excerpt":"Hello everybody, I did not find my answer in the different discussions, then I hope you will be able to help me. I have a smart sheet with 2 columns: Part number Quantity I would like to count the total of parts with a certain number. Finally, it is an addition of the quantity when the P\/N is equal to a certain value. I…","categoryID":322,"dateInserted":"2023-06-21T06:31:14+00:00","dateUpdated":"2023-06-21T07:41:41+00:00","dateLastComment":"2023-06-21T11:14:19+00:00","insertUserID":159154,"insertUser":{"userID":159154,"name":"Guillaume B.","url":"https:\/\/community.smartsheet.com\/profile\/Guillaume%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S5NT3AR3967R\/nA4FRK2S3XJG9.jpg","dateLastActive":"2023-06-21T13:09:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":159154,"lastUserID":159154,"lastUser":{"userID":159154,"name":"Guillaume B.","url":"https:\/\/community.smartsheet.com\/profile\/Guillaume%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S5NT3AR3967R\/nA4FRK2S3XJG9.jpg","dateLastActive":"2023-06-21T13:09:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":3374676333,"url":"https:\/\/community.smartsheet.com\/discussion\/106682\/make-sum-of-one-column-in-function-of-value-of-another","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106682\/make-sum-of-one-column-in-function-of-value-of-another","format":"Rich","lastPost":{"discussionID":106682,"commentID":381436,"name":"Re: Make sum of one column in function of value of another","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381436#Comment_381436","dateInserted":"2023-06-21T11:14:19+00:00","insertUserID":159154,"insertUser":{"userID":159154,"name":"Guillaume B.","url":"https:\/\/community.smartsheet.com\/profile\/Guillaume%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/S5NT3AR3967R\/nA4FRK2S3XJG9.jpg","dateLastActive":"2023-06-21T13:09:56+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T11:14:29+00:00","dateAnswered":"2023-06-21T11:14:19+00:00","acceptedAnswers":[{"commentID":381436,"body":"

I finally found the correct formula:<\/p>

=SUMIF([Part number]$185:[Part number]$369, CONTAINS([Part number]167, @cell), Quantity$185:Quantity$369)<\/code><\/strong><\/p>

Like that it is working partially, because as I have sub assemblies, I will need to take the quantity of the PARENT() and multiply it to have the correct value.<\/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":106658,"type":"question","name":"How do I fill a date series from left to right?","excerpt":"I found an answer with an incredibly complicated formula for text fields, but I wanted to ask again just to be certain - is there no way to drag-fill a date series from left to right in Smartsheets? I don't want the entire column to be dates, just the one row, so you can see that Week 25 is the week of 6\/19\/23, for…","categoryID":322,"dateInserted":"2023-06-20T18:50:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-21T18:24:14+00:00","insertUserID":162215,"insertUser":{"userID":162215,"name":"Jessica Weiss","title":"Production Manager","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Weiss","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvtc5xY6nz0!!XANJ4bk168O","dateLastActive":"2023-06-21T18:24:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162215,"lastUser":{"userID":162215,"name":"Jessica Weiss","title":"Production Manager","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Weiss","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvtc5xY6nz0!!XANJ4bk168O","dateLastActive":"2023-06-21T18:24:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":49,"score":null,"hot":3374666711,"url":"https:\/\/community.smartsheet.com\/discussion\/106658\/how-do-i-fill-a-date-series-from-left-to-right","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106658\/how-do-i-fill-a-date-series-from-left-to-right","format":"Rich","lastPost":{"discussionID":106658,"commentID":381580,"name":"Re: How do I fill a date series from left to right?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381580#Comment_381580","dateInserted":"2023-06-21T18:24:14+00:00","insertUserID":162215,"insertUser":{"userID":162215,"name":"Jessica Weiss","title":"Production Manager","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Weiss","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvtc5xY6nz0!!XANJ4bk168O","dateLastActive":"2023-06-21T18:24:29+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,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-21T18:00:43+00:00","dateAnswered":"2023-06-21T17:37:22+00:00","acceptedAnswers":[{"commentID":381561,"body":"

I missed a small piece in my formula. Is there a face palm emoji? Ugh. There should also be a $ before the first cell reference to lock that one in as well to keep it from updating during dragfill.<\/p>


<\/p>

=($[W1]@row + (7 * COUNT($[W1]@row:[W1]@row))) + \"//www.santa-greenland.com/community/discussion/41261/\"<\/p>"},{"commentID":381571,"body":"

💥 BOOM! 💥 That did it, my friend! Thank you so much, @Paul Newcome<\/a>!<\/p>

\n
\n \n \"Screenshot<\/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":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":[]}],"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":[]}">

公式和函数趋势

  • 如果或公式帮助

    我的公式在Excel中工作，但在Smartsheet中不行。我仍然是相当新的智能表，所以任何帮助将不胜感激。它查看GLAcct列，找到某些值并为这些值创建关键字。例如:如果GLAcct = 710111或710121，则显示Key Salary。

  • 求一列值与另一列值的和

    大家好，我在不同的讨论中没有找到我的答案，希望大家能够帮助我。我有一个智能表，有两列:零件编号数量我想计算零件的总数与一定的数字。最后，当P/N等于某一值时，它是数量的加法。我…

  • 如何从左到右填写日期系列?

    我找到了一个非常复杂的文本字段公式的答案，但我想再问一次，只是为了确定-有没有办法从左到右拖动填充智能表格中的日期系列?我不希望整列都是日期，只有一行，所以你可以看到第25周是6/19/23，对于……