仪表板/报告-标签
我正在建立一个基于报告的仪表板，该报告是由4个不同的表的表摘要创建的。下面的小部件显示了2020年、2021年、2022年和2023年至今的情况。我希望该列的蓝点或底部反映与值相关的年份。
我确信它一定是在这个过程的早期某个地方，但很难确定要修改什么来实现这一点?目前，日期仅基于工作表，信息不位于列中。
答案
帮助文章参考资料欧宝体育app官方888
类别
Try this:<\/p>
=IF([Date of Site Survey (Product)]@row <> \"//www.santa-greenland.com/community/discussion/103140/\", IF(TODAY() > [Date of Site Survey (Product)]@row, \"yes\", \"no\"))<\/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":106244,"type":"question","name":"Multi-part formula with multi select field using references issue","excerpt":"Hello- I am trying to write a formula that includes sheet references, and two conditions. I need to count the number of students in each category and how many of those students chose a specific availability time from a multi-select drop-down menu. This is what I came up with but doesn't work. =COUNTIFS({Student Type},…","categoryID":322,"dateInserted":"2023-06-08T21:31:20+00:00","dateUpdated":null,"dateLastComment":"2023-06-09T14:55:22+00:00","insertUserID":125320,"insertUser":{"userID":125320,"name":"Kimberly Slavsky","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Slavsky","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:59:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":125320,"lastUser":{"userID":125320,"name":"Kimberly Slavsky","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Slavsky","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:59:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3372583602,"url":"https:\/\/community.smartsheet.com\/discussion\/106244\/multi-part-formula-with-multi-select-field-using-references-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106244\/multi-part-formula-with-multi-select-field-using-references-issue","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":106244,"commentID":379845,"name":"Re: Multi-part formula with multi select field using references issue","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379845#Comment_379845","dateInserted":"2023-06-09T14:55:22+00:00","insertUserID":125320,"insertUser":{"userID":125320,"name":"Kimberly Slavsky","url":"https:\/\/community.smartsheet.com\/profile\/Kimberly%20Slavsky","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-09T14:59:34+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-09T14:55:06+00:00","dateAnswered":"2023-06-09T05:19:35+00:00","acceptedAnswers":[{"commentID":379763,"body":"
Hi Kimberly, try this.<\/p>
=COUNTIFS({Student Type}, \"University Student\", {Student Availability}, HAS(@cell, \"Monday AM\"))<\/p>
--Anson<\/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"}]},{"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-09T14:05:37+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-09T14:01:37+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-09T14:01:37+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":34,"score":null,"hot":3372574224,"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":379826,"name":"Re: Check if project start\/end dates fall within specific time frame.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/379826#Comment_379826","dateInserted":"2023-06-09T14:05:37+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-09T14:01:37+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-09T14:05:51+00:00","dateAnswered":"2023-06-09T14:05:37+00:00","acceptedAnswers":[{"commentID":379826,"body":"
