Reference Data from report

Joanna Chu
edited 12/30/21 in Formulas and Functions


We have lots of project sheets which must be got their project end date. Then I use the sheet summary function to get that valuable information from every project sheet. Then I got a report of all project end dates. Unfortunately, a few projects don't use Smartsheet. So, I created a sheet and shared it with them to maintain their project end date. The question is I can't combine these two (because sheet reference data could only be a sheet). Is any way to solve this? Thanks.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!