I have 4 dates in 4 different columns. I need to pull a date that lands in this week.

Valeri Nguyen
Valeri Nguyen âś­âś­
edited 02/12/21 in Formulas and Functions

I have 4 different columns for dates: Phase 1, Phase 2, Phase 3, Phase 4. I am trying to find a formula that can pull any date that falls in the current week and populate that date into a cell. Some fields may have "N/A" in them instead of a date.

Is there a way to do this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!