Sign in to submit new ideas and vote
Get Started

Update formula wizard when used in sheet summary

Phil Wightman
Phil Wightman ✭✭✭✭✭✭

This is because the wizard only offers 'Reference another sheet' when this is slightly illogical as you are in sheet summary ie to summarise the sheet you are in.

You then cant click on the column header to add the range to the formula when using sheet summary without an error. The way to add the range is to scroll down the rows in the column you want included. This can be problematic if more rows are added outside of the range in the formula.

Just fixing the column header issue would be helpful.

2 votes

Idea Submitted · Last Updated