重置一行

SYDPEN
SYDPEN ✭
在公式与函数

你好,

我正在寻找一种方法，有某些单元格在一行“重置”一次复选框(在同一行)被选中。当我说“重置”，我想要两个单元格返回为空，另一个单元格有一个更新的数量。

有办法做到这一点吗?也许是多重自动化?

感谢任何帮助或建议!

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

答案

帮助文章资源欧宝体育app官方888

在Smartsheet中创建和编辑公式

交叉表引用的公式组合

Smartsheet功能列表

类别

Hi @peter65516<\/a> <\/p>

I hope you're well and safe!<\/p>

Try something like this.<\/p>

=SUMIFS([Hoggets - Number]:[Hoggets - Number], [Preferred Start Date]:[Preferred Start Date], < (TODAY() + 8)<\/p>

Did that work\/help? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

<\/p>

✅Please support the Community by marking the post(s)<\/em> <\/em><\/strong>that<\/em> <\/em><\/strong>helped or answered your question or solved your problem with <\/em>the accepted answer\/helpful, Insightful\/Vote Up\/Awesome<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-27 01:02:10","updateUser":{"userID":65516,"name":"peter65516","url":"https:\/\/community.smartsheet.com\/profile\/peter65516","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zrlHc6VN3Lo!24_A_3q44n4!GDoXnCGro8M","dateLastActive":"2022-10-27T07:28:31+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":97033,"type":"question","name":"simple date range question","excerpt":"Hello, I feel silly for asking this, so I hope this is easy. I cannot find a simple answer on this anywhere. Every question I read date ranges is about some complicated calculations with other data etc.. I simply want to have a formula that either combines two dates to show a range or calculate a range based on just adding…","categoryID":322,"dateInserted":"2022-10-26T19:40:51+00:00","dateUpdated":null,"dateLastComment":"2022-10-26T22:28:25+00:00","insertUserID":147546,"insertUser":{"userID":147546,"name":"Nick Amsler","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Amsler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T22:23:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148574,"lastUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T22:24:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":31,"score":null,"hot":3333638956,"url":"https:\/\/community.smartsheet.com\/discussion\/97033\/simple-date-range-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97033\/simple-date-range-question","format":"Rich","lastPost":{"discussionID":97033,"commentID":348871,"name":"Re: simple date range question","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348871#Comment_348871","dateInserted":"2022-10-26T22:28:25+00:00","insertUserID":148574,"insertUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T22:24:04+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":"2022-10-26T22:26:46+00:00","dateAnswered":"2022-10-26T21:45:09+00:00","acceptedAnswers":[{"commentID":348860,"body":"

Hi @Nick Amsler<\/a>,<\/p>

Once you use a double quote in a formula, your date becomes part of a string (text).<\/p>

I just tested this formula against two date column I have, and it worked: <\/p>

=([Target Start Date]@row + \" - \" + [Target End Date]@row)<\/p>

**Modify the column names to your own.<\/p>

Here is the result:<\/p>

03\/13\/23 8:00 AM - 03\/17\/23 4:59 PM<\/p>

You could get fancy with it if you wanted to parse out the times.<\/p>


<\/p>

Hope this helps!<\/p>

All the best,<\/p>

-Ray<\/p>"},{"commentID":348862,"body":"

@Nick Amsler<\/a> <\/p>

Hey Nick, you were close! Give this a try...<\/p>

=[XX Date]@row + \" - \" + ([XX Date]@row + 14)<\/p>

Lemme know if that works for you!<\/p>

-Ryan<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-26 22:26:46","updateUser":{"userID":147546,"name":"Nick Amsler","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Amsler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-26T22:23:10+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":97025,"type":"question","name":"Copy Date from one sheet to another if criteria matches","excerpt":"Hello all, I have a master project sheet and I'd like to copy the date from another sheet into it. Below is my master sheet and in the Milestone Date column, I want to copy the End Date from Project Sheet (below), if the \"Primary Column\" name from the Project sheet at each line matches the \"Project Name\" line name in the…","categoryID":322,"dateInserted":"2022-10-26T17:34:22+00:00","dateUpdated":"2022-10-26T17:51:03+00:00","dateLastComment":"2022-10-26T20:49:18+00:00","insertUserID":131616,"insertUser":{"userID":131616,"name":"Andrea Westrich","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Westrich","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!06vS_zj5Rrw!!Vj-bj4lNhSM","dateLastActive":"2022-10-26T23:39:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":131616,"lastUserID":148574,"lastUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T22:24:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":16,"score":null,"hot":3333624820,"url":"https:\/\/community.smartsheet.com\/discussion\/97025\/copy-date-from-one-sheet-to-another-if-criteria-matches","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/97025\/copy-date-from-one-sheet-to-another-if-criteria-matches","format":"Rich","lastPost":{"discussionID":97025,"commentID":348835,"name":"Re: Copy Date from one sheet to another if criteria matches","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/348835#Comment_348835","dateInserted":"2022-10-26T20:49:18+00:00","insertUserID":148574,"insertUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu03N-eM91LppALCfccJ9FAxCZ9_6rqdFYbvOL4lgA=s96-c","dateLastActive":"2022-10-26T22:24:04+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\/7ECJRG9ASCDM\/screen-shot-2022-10-26-at-12-24-02-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2022-10-26 at 12.24.02 PM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-26T19:14:55+00:00","dateAnswered":"2022-10-26T18:49:56+00:00","acceptedAnswers":[{"commentID":348810,"body":"

@Andrea Westrich<\/a> <\/p>

Hi Andrea, if your cross sheet references are setup correctly, it looks like your issue might be a typo.<\/p>

Replace your period after @row with a comma.<\/p>

=INDEX({ZLINE - Project Milestone Checklist End Date}, MATCH([Project Name]@row, {ZLINE - Project Milestone Checklist Primary Column}, 0))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-26 19:14:55","updateUser":{"userID":131616,"name":"Andrea Westrich","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Westrich","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!06vS_zj5Rrw!!Vj-bj4lNhSM","dateLastActive":"2022-10-26T23:39:49+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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">