Reference Data from report
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
Check out the Formula Handbook template!