Reference Data from report

Joanna Chu

Hi

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.

Andrée Starå

Hi @Joanna Chu

You'd have to add separate sheets for the other projects as well, but you could use cross-sheet formulas to connect them to the sheet you're using now.

Would that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!