Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formulas that work across sheets
With no pivot table functionality & Reports having no aggregating functionality, and Sights having on wigdet capable of aggregating data we struggle to summarise or aggregate our data up.
We could create a summary sheets that count/sum our data in other sheets IF Smartsheet allowed formulas across sheets (which it currently doesn't).
If you would like the Smartsheet Dev. team to work on allowing us to use cross sheet formulas then please show you support by liking this post. the more likes this post gets the more likely the dev team are to solution it.