Inconsistent Date Options
Hi
I recently came across 2 date-related options which look inconsistent within the app.
Would be grateful if the smartsheet development team can address it soonest!
The Inconsistency:
In the Workflow-Automation we can set a Condition as<any date field> is not today; whereas in the Conditional Formatting dialog, we don't have this particular date-field evaluation parameter (i.e., "isnottoday").
The presence of this evaluation parameter in the Conditional Formatting dialog would make it much easier to ignore everything else and just monitor today's dates in the data!
Please see the attached screenshots.
Comments
-
Andrée Starå ✭✭✭✭✭✭
Hi Nasir,
I agree and it would be a great addition to the list of options.
Please submit an Enhancement Request when you have a moment.
As a possible workaround, you can check the checkbox in the bottom,Apply format when condition is NOT met.
I hope that helps!
有一个很好的一天!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå| Workflow Consultant / CEO @WORK BOLD
W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
Categories
Latest from Zapier Support.<\/p>
\"I've submitted this feature request on your behalf. That does a few things:<\/em><\/strong><\/p> While I don't have an ETA on when this feature might be implemented, we will notify you via email if it is!<\/em><\/strong><\/p> Prioritization is largely dependent on the number of customers affected. Issues with only one interested customer will be auto-closed after 3 years.<\/em><\/strong><\/p> I'm sorry, I wish I had a more immediate solution for you. It never hurts for you to reach out to the app developer directly (Smartsheet in this case) to let them know you're running into an issue with their Zapier integration. We do notify them from our end, but a nudge from their users can sometimes carry more weight!\"<\/em><\/strong><\/p> --<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":106323,"type":"question","name":"What are we to do when a considerable number of people are receiving 504 Gateway Timeout?","excerpt":"No one is able to login to the Smartsheet's website.","categoryID":321,"dateInserted":"2023-06-12T15:29:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-12T16:24:28+00:00","insertUserID":158199,"insertUser":{"userID":158199,"name":"AllenWeston","url":"https:\/\/community.smartsheet.com\/profile\/AllenWeston","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-12T16:19:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-13T15:57:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":55,"score":null,"hot":3373172662,"url":"https:\/\/community.smartsheet.com\/discussion\/106323\/what-are-we-to-do-when-a-considerable-number-of-people-are-receiving-504-gateway-timeout","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106323\/what-are-we-to-do-when-a-considerable-number-of-people-are-receiving-504-gateway-timeout","format":"Rich","lastPost":{"discussionID":106323,"commentID":380131,"name":"Re: What are we to do when a considerable number of people are receiving 504 Gateway Timeout?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380131#Comment_380131","dateInserted":"2023-06-12T16:24:28+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-13T15:57:07+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-06-12T15:34:20+00:00","dateAnswered":"2023-06-12T15:31:38+00:00","acceptedAnswers":[{"commentID":380118,"body":" Hi @AllenWeston<\/a> <\/p> I hope you're well and safe!<\/p> There's a known issue at the moment.<\/p>