Add Virtual Hierarchy to Reports

We love Smartsheet reports as they are so powerful. But one frustration we share with many people we speak to is that you lose the hierarchy or indentation when you important a sheet into a report.

After being asked about this yet again, we had a little think and thought there is a way of doing this more creatively by using a helper column and adding chevrons to mark the indentation.

We can't include the formula in this description as it includes special characters that you can't use in the YouTube description field, so head over to our website and grab it from there: https://www.getprodactive.com/demo-as...

We're an award-winning Smartsheet partner with team members in the UK, USA and South Africa, helping clients all over the world, from North America to Australia, achieve great things with Smartsheet.

Rich Coles has over 20 years experience working within multi-national organisations helping deliver projects and programmes at a local and global level, from new product launches in FMCG, to people and process transformation in pharma, refurbishments in retail and real estate.

Leveraging this experience, a core expertise in cross-functional working, project and programme management and a deep knowledge of how to get the best out of Smartsheet, we help organisations maximise productive working and unlock unrealised business opportunities by harnessing the power of data and business insights.

Any questions, or for help with your PMO Smartsheet solution, including using any of Prodactive's extensive range of solutions, please get in touch.

https://www.getprodactive.com/
  / richard-coles