公式帮助
你好,
为了完成这个模板，我需要算出最后一个公式。@Kelly摩尔你帮了我很大的忙，如果你能在这最后一个问题上帮我，我欠你一个人情!
我知道公式里有个错误或者用错了。我正试图在当前工作表上拉起开始日期和结束日期，同时考虑到项目名称，并在其他电子表格中拉出日期范围内每天的总产量。ob欧宝娱乐app手机下载
=SUMIFS({每日总产量}ob欧宝娱乐app手机下载);
{生成跟踪器范围1}，
(项目名称)@row,
{生成跟踪器范围2}，
>=" &[起始日期]@row，
{生成跟踪器范围2}，
<=" & [End Date]@row)
这是我试图从电子表格中提取数据:
这是我正在使用的电子表格。似乎没有在看当前的电子表格字段。我突出显示我试图匹配的字段以获得SUM。
谢谢你的帮助!我很高兴能把这个电子表格交给团队!
最佳答案
-
凯利摩尔 ✭✭✭✭✭✭
很乐意帮忙。将来需要注意的一些语法错误—我相信在您的公式中，您正在尝试使用&作为连接。这是不必要的和智能表不使用&符号连接。当需要连接时，使用加号。但是你不需要在任何表达式的其他部分加入等号。此外，用引号括起数字或算术符号将它们转换为文本字符串，在文本字符串中，它们的行为就像在句子中放入字母表中的任何其他字母一样。
感谢截图和输入的公式。两者都非常有用。
=SUMIFS({每天总产量}ob欧宝娱乐app手机下载，{生成跟踪器范围1}，[项目名称]@row，{生成跟踪器范围2}，>=[开始日期]@row，{生成跟踪器范围2}，<=[结束日期]@row)
这对你有用吗
凯利
答案
-
凯利摩尔 ✭✭✭✭✭✭
很乐意帮忙。将来需要注意的一些语法错误—我相信在您的公式中，您正在尝试使用&作为连接。这是不必要的和智能表不使用&符号连接。当需要连接时，使用加号。但是你不需要在任何表达式的其他部分加入等号。此外，用引号括起数字或算术符号将它们转换为文本字符串，在文本字符串中，它们的行为就像在句子中放入字母表中的任何其他字母一样。
感谢截图和输入的公式。两者都非常有用。
=SUMIFS({每天总产量}ob欧宝娱乐app手机下载，{生成跟踪器范围1}，[项目名称]@row，{生成跟踪器范围2}，>=[开始日期]@row，{生成跟踪器范围2}，<=[结束日期]@row)
这对你有用吗
凯利
-
@Kelly摩尔那工作!这真是太有帮助了。感谢你能帮我收拾残局。:)你太棒了!
-
凯利摩尔 ✭✭✭✭✭✭
我总是很乐意帮忙。你可能会发现这些链接对公式很有用:
https://help.smartsheet.com/topics/Formulas%20and%20Functions
随时可以大声喊出来。周末愉快
凯利
帮助文章参考资料欧宝体育app官方888
类别
=IF(AND([Build Approved]@row = 1, [Install Complete]@row = 1, [In Production]@row = 1), \"In Production\", IF(AND([Build Approved]@row = 1, [Install Complete]@row = 1, [In Production]@row = 0), \"Installed\", IF(AND([Build Approved]@row = 1, [Install Complete]@row = 0, [In Production]@row = 0), \"Build Approved\", \"Design\")))<\/p>"},{"commentID":379709,"body":"
=IF([Build Approved]@row = 0, \"Design\", IF([Install Complete]@row = 0, \"Build Approved\", IF([In Production]@row = 0, \"Installed\", \"In Production\")))<\/p>
This may work.<\/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":106232,"type":"question","name":"Check if project start\/end dates fall within specific time frame.","excerpt":"My team works on projects that typically take 6-12 months. I'd like to create a roll-up sheet that identifies which quarters in which a project was worked on. I'm creating a new row for each project and linking in the start and end dates from each of the projects' sheets. Then I've created a new column for each quarter…","categoryID":322,"dateInserted":"2023-06-08T19:44:47+00:00","dateUpdated":"2023-06-08T22:03:24+00:00","dateLastComment":"2023-06-08T20:08:51+00:00","insertUserID":161563,"insertUser":{"userID":161563,"name":"gunnell","title":"Director, eLearning Initiatives","url":"https:\/\/community.smartsheet.com\/profile\/gunnell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T22:02:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":161563,"lastUserID":161563,"lastUser":{"userID":161563,"name":"gunnell","title":"Director, eLearning Initiatives","url":"https:\/\/community.smartsheet.com\/profile\/gunnell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T22:02:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":23,"score":null,"hot":3372509018,"url":"https:\/\/community.smartsheet.com\/discussion\/106232\/check-if-project-start-end-dates-fall-within-specific-time-frame","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106232\/check-if-project-start-end-dates-fall-within-specific-time-frame","format":"Rich","lastPost":{"discussionID":106232,"commentID":379713,"name":"Re: Check if project start\/end dates fall within specific time frame.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379713#Comment_379713","dateInserted":"2023-06-08T20:08:51+00:00","insertUserID":161563,"insertUser":{"userID":161563,"name":"gunnell","title":"Director, eLearning Initiatives","url":"https:\/\/community.smartsheet.com\/profile\/gunnell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T22:02:45+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-08T20:09:01+00:00","dateAnswered":"2023-06-08T20:08:51+00:00","acceptedAnswers":[{"commentID":379713,"body":"
<\/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":106219,"type":"question","name":"Metrics NOT updating periodically as expected","excerpt":"Not sure if anyone is experiencing this. I've created a METRICS sheet for every project that sums up counts for Task Health in order to present on Dashboard through Graphs. I'm noticing that theses metrics are NOT automatically updated unless I refresh the page a dozen times OR re-write the exact same formula again. But…","categoryID":322,"dateInserted":"2023-06-08T17:33:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-08T21:33:47+00:00","insertUserID":161931,"insertUser":{"userID":161931,"name":"Christine Cao","title":"Engagement Manager","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Cao","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T21:32:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":161931,"lastUser":{"userID":161931,"name":"Christine Cao","title":"Engagement Manager","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Cao","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T21:32:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":36,"score":null,"hot":3372508061,"url":"https:\/\/community.smartsheet.com\/discussion\/106219\/metrics-not-updating-periodically-as-expected","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106219\/metrics-not-updating-periodically-as-expected","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106219,"commentID":379733,"name":"Re: Metrics NOT updating periodically as expected","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379733#Comment_379733","dateInserted":"2023-06-08T21:33:47+00:00","insertUserID":161931,"insertUser":{"userID":161931,"name":"Christine Cao","title":"Engagement Manager","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Cao","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-08T21:32:12+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\/FUCVWKMTVZVX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-08T21:32:09+00:00","dateAnswered":"2023-06-08T21:03:22+00:00","acceptedAnswers":[{"commentID":379727,"body":"
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/JF3BGCEG3XMR\/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":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"}]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">