Pull a calendar

edited 12/09/19 in Formulas and Functions

Hi-- so, I have a series of columns representing various tasks. And then I have a series of rows representing various projects. I enter various dates into the corresponding cells (eg Project X and Task Y will occur on such and such date).


What I want to do then is on a separate sheet list all of the dates in the year and then have Smartsheet automatically pull the tasks/projects associated with a given date. So some dates would have nothing associated, and others might have several project/task pairs.


In a sense, this is a calendar view, which is fine, although I'd rather see it in list view.


Thoughts? Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!