Pulling Cells Information by Date into Sheet Summary

Hi All,

I'm pretty new at Smartsheet and I'm getting the hang of it, but I'm stuck on this one. What formula can I use to pull in any Location name that has a "Live Date" within 2 weeks of today's date?

Here's my table:

Any help would be greatly appreciated!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!