Is there a way to have the indent feature but to hide comments on a published sheet?
I have a sheet that I want to share by publishing but I don't want comments to be visible because they contain sensitive data. I am using the indent feature which allows rows to be expanded and collapsed to
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region (I do a cell reference) it doesn't seem to work. For
I have users completing a form to update a source sheet I use for a Dashboard. Once the sourcesheet is updated I would like to show the latest update in realtime with having to update the dashboard manually. Is this possible? If so what would I need to do? Could I use a report or a