6

Hi, 


I have several standard grid sheets that are populated via webforms,  we are based within the UK. 


The issue I have is that I don't seem able to include "indent" function to the rows (i'd like to indent per month), as the sheets are growing huge as we have a lot of data being submitted from remote and field workers. So our project managers are having to scroll right past all the historical data to see the relevant fields and its becoming a pain. 


What can we do to include this function and make the sheets feel less overloaded?


Regards

Stuart  

Comments

Indentation would have to be done manually. There is no way to automate it based off of form submissions or otherwise. You could also use a filter or report to pull the relevant data.

You could also make your forms add new rows to the top of the sheet instead of the bottom. That would circumvent scrolling. But I second, Paul's idea of creating a report. A report can pull from one or more sheets and can be filtered based on content in the sheet itself. If you are capturing the dates the rows are added in a system column type, for instance, you could only include rows that are 60 days old or newer. Or if you're tracking completions statuses, you could include rows that are not complete. That would eliminate unnecessary information for your users. Here are some links on making reports.

https://help.smartsheet.com/articles/522214-creating-reports

https://help.smartsheet.com/videos/smartsheet-reports

In reply to by Mike Wilday

Hi, 


Thanks for the feedback both! 


It won't let me manually indent. It Just doesn't include the minimising button, the ident icons do not appear when I add a row to the top, but when I try indent from rows beneath the ident icons do appear but nothing happens when I select the button.  I use this function on other sheets (that are not populated by webforms) to good effect, however its simply not doing it on the sheets with forms. 


I've found the option to have the form populate the top of the sheet, however is there a way to spin the existing data around? 


As this will only work for new submissions and then confuse our processes,


Regards 

Andree_Stara

Hi Stuart,

Smartsheet mentioned functionality that is coming for moving rows and more and that might help. We'll have to wait and see how it will work.

I hope this helps you!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

The indentation issue could be caused by a blank cell in your primary column. To indent row 2 you MUST have data in the primary column of row 1. To indent row 3, you need data in the primary column of row 2, etc. In your screenshot where you have row 2 selected as the start of your range, there is no data in the row above it.