1. is it possible (and how) to allow users to change values in a column of a sheet in a report. But i dont want to let them change other things in the data sheet behind. In best case they can't open the sheet because there may be columns which are not for their eyes.
is it possible to get the sum or count of a filtered sheet or in a report?
I want to know how many lines are filled with data. I use the count(children()) function. In one cell are the nicks of the employees (like "KOV, SEA, KEP ..."). Now I set a filter that only shows me lines where
my problem is that the smartsheet has around 3000 lines ... so it's nearly immpossible to work with this sheet. That's not the main problem because our users just work with sights an reports to this sheet - no problem with speed.
Most of the lines are finished. But we have to store them for further