Formula Date Not Syncing With Conditional Formatting
Hi, I'm trying to automate my start date and due date columns. In order to do this, I'm essentially hard coding the month and day piece of the function (e.g. "01/01") and then extracting the annual piece of the function from the Task column (e.g. "2024" to "24"). The output, I believe, is similar as it would be in excel and is being recognized as a "text" format, as opposed to a date format. As a result, the Gantt chart is not picking it up nor is that value able to be used in my standing formula (as shown below).
My question, then, is there a formula or way to convert this text format into a date format so that my formulas work appropriately?
Best Answer
-
@aaronh123 Yes, when you use a formula like the right() it does convert it to text and loses the date functionality. You would bury that into a date() formula to keep the date functionality.
Try this:
=DATE(VALUE(RIGHT(Task@row, 2)), 1, 1)
Answers
-
@aaronh123 Yes, when you use a formula like the right() it does convert it to text and loses the date functionality. You would bury that into a date() formula to keep the date functionality.
Try this:
=DATE(VALUE(RIGHT(Task@row, 2)), 1, 1)
-
Thanks Matt,
That worked very well for us, thank you!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 201 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives