日历上的货币视图

在我的智能表日历中显示货币视图有问题。它从中提取的数据集具有正确的格式。不知道我做错了什么。

标签:

答案

Is there an option for \"Has Any Of\"?<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-13 22:08:02","updateUser":{"userID":156010,"name":"AliT","url":"https:\/\/community.smartsheet.com\/profile\/AliT","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!80tRN2Ch-HQ!nDHdH1rxiPw!1_-nYVqJJzq","dateLastActive":"2023-01-13T22:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":99633,"type":"question","name":"Trying to do a filter base on a date","excerpt":"I am capturing time and attendance. I have a field called Week Ending (Saturday) . I would like to to display the The previous week timecards for 5 days after the week ending date then I want the report to only show the new entries from that point until the 5 days past the end date repeating the cycle","categoryID":321,"dateInserted":"2023-01-12T21:27:56+00:00","dateUpdated":null,"dateLastComment":"2023-01-13T14:40:39+00:00","insertUserID":155543,"insertUser":{"userID":155543,"name":"TLaGrant","url":"https:\/\/community.smartsheet.com\/profile\/TLaGrant","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp6EQQZFHWUvVwnZL055h4dGhpjvSH_-856qENAf=s96-c","dateLastActive":"2023-01-13T21:11:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":155543,"lastUser":{"userID":155543,"name":"TLaGrant","url":"https:\/\/community.smartsheet.com\/profile\/TLaGrant","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp6EQQZFHWUvVwnZL055h4dGhpjvSH_-856qENAf=s96-c","dateLastActive":"2023-01-13T21:11:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3347181515,"url":"https:\/\/community.smartsheet.com\/discussion\/99633\/trying-to-do-a-filter-base-on-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99633\/trying-to-do-a-filter-base-on-a-date","format":"Rich","lastPost":{"discussionID":99633,"commentID":357061,"name":"Re: Trying to do a filter base on a date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/357061#Comment_357061","dateInserted":"2023-01-13T14:40:39+00:00","insertUserID":155543,"insertUser":{"userID":155543,"name":"TLaGrant","url":"https:\/\/community.smartsheet.com\/profile\/TLaGrant","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp6EQQZFHWUvVwnZL055h4dGhpjvSH_-856qENAf=s96-c","dateLastActive":"2023-01-13T21:11:56+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-01-13T14:40:57+00:00","dateAnswered":"2023-01-12T22:49:56+00:00","acceptedAnswers":[{"commentID":357023,"body":"

@TLaGrant<\/a> <\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

You'll want to setup 2 filters with the OR between them like the screenshot above. The first one you'll select \"is in the last (days)\" and the other one you'll select \"is in the next (days)\".<\/p>

If you need to exclude a day such as today, you'd set it up like this:<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"},{"commentID":357061,"body":"

Ended up with this ! TY<\/p>


<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-13 14:40:44","updateUser":{"userID":155543,"name":"TLaGrant","url":"https:\/\/community.smartsheet.com\/profile\/TLaGrant","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp6EQQZFHWUvVwnZL055h4dGhpjvSH_-856qENAf=s96-c","dateLastActive":"2023-01-13T21:11:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"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":[]},{"discussionID":99618,"type":"question","name":"Best practice for sending notificatons from 1 smartsheet based on users in a 2nd smartsheet","excerpt":"Hi, I have a master smartsheet with client name, a date and the clients product lines, on a row. The product line column is a multiple select, restricted to a specific list of values. I have second smartsheet by department and users within the department. I am thinking of adding the product lines which the department is…","categoryID":321,"dateInserted":"2023-01-12T18:27:51+00:00","dateUpdated":null,"dateLastComment":"2023-01-12T23:20:36+00:00","insertUserID":35911,"insertUser":{"userID":35911,"name":"Peggy","url":"https:\/\/community.smartsheet.com\/profile\/Peggy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7Htee2AaTfQ!htPdobx0PT4!J2mAMiaMDmW","dateLastActive":"2023-01-12T23:19:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":35911,"lastUser":{"userID":35911,"name":"Peggy","url":"https:\/\/community.smartsheet.com\/profile\/Peggy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7Htee2AaTfQ!htPdobx0PT4!J2mAMiaMDmW","dateLastActive":"2023-01-12T23:19:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":47,"score":null,"hot":3347115507,"url":"https:\/\/community.smartsheet.com\/discussion\/99618\/best-practice-for-sending-notificatons-from-1-smartsheet-based-on-users-in-a-2nd-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99618\/best-practice-for-sending-notificatons-from-1-smartsheet-based-on-users-in-a-2nd-smartsheet","format":"Rich","lastPost":{"discussionID":99618,"commentID":357036,"name":"Re: Best practice for sending notificatons from 1 smartsheet based on users in a 2nd smartsheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/357036#Comment_357036","dateInserted":"2023-01-12T23:20:36+00:00","insertUserID":35911,"insertUser":{"userID":35911,"name":"Peggy","url":"https:\/\/community.smartsheet.com\/profile\/Peggy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7Htee2AaTfQ!htPdobx0PT4!J2mAMiaMDmW","dateLastActive":"2023-01-12T23:19: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-01-12T23:19:42+00:00","dateAnswered":"2023-01-12T23:06:01+00:00","acceptedAnswers":[{"commentID":357031,"body":"

@Peggy<\/a> <\/p>

You're right about adding the Product Lines to the 2nd sheet with the department\/users. After you do that, on the 1st sheet you'll want to use an INDEX\/MATCH formula which drags in the user who needs the notification. You'll match against the product line listed on sheet 1 and 2.<\/p>

Once you've got that setup and working, on the 1st sheet you can create an automation which is triggered by the date field and alerts the contact field which is the user who's INDEX\/MATCHed from the 2nd sheet.<\/p>"},{"commentID":357032,"body":"

@Peggy<\/a> <\/p>

You may need to use an INDEX\/COLLECT formula instead if you have multiple people listed on the 2nd sheet and you want to pull in someone with a specific title. COLLECT will help you specify multiple criteria which would be the product line criteria and the person's title criteria.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2023-01-12 23:19:42","updateUser":{"userID":35911,"name":"Peggy","url":"https:\/\/community.smartsheet.com\/profile\/Peggy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7Htee2AaTfQ!htPdobx0PT4!J2mAMiaMDmW","dateLastActive":"2023-01-12T23:19:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">