Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Conditional Formula to highlight all dates = Today

✭✭✭✭
edited 01/29/25 in Formulas and Functions

I am still working on my same template. Now there are multiple dates that are using formulas. I would like to be able to use a formula within conditional formatting for this range. When I attempted to do this and selected the word "today" it put in today's date. When tomorrow arrives, that will obviously not be helpful. Basically what I want is:

Highlight all dates = TODAY in bright Yellow

Sherry Fox

Business Process Analyst 3 | C5ISR Group | HII | Mission Technologies

EAP | Mobilizer | Automagician | Superstar | Community Champion Class of 2024

Core App Certified 🦊

NEW (Work) Profile: @SherryFox | OLD (Personal) Profile: @Sherry Fox

Connect with me on LinkedIn

Please Like ❤️, Vote Up ⬆️, Awesome 🤩, Insightful 🧐 any of my contributions that have provided value.

Best Answer

  • ✭✭✭✭✭✭
    Answer ✓

    Hi @SherryFox,

    As long as your column is a date column you can try the following. Instead of typing in Today with an operator like "is equal to", use the Date "is today" criteria.

    Is that what you're trying to accomplish? It seems to have worked for me, and will work tomorrow and everyday thereafter.

    All the best,
    -Ray

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions