Extract a value if today is between start and end date

Hi all,

I've been trying to wrap my head around this and I have trouble trying to self serve to find an answer (or it's just user error on my end haha)

I have a schedule with 3 main columns - the name, the start date and the end date. What I was hoping to do was extract who is currently scheduled if today was equal greater than the start date and if today was less than the end date. It seemed easy enough in my head but I may be doing something wrong.

Anyone have any suggestions?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!