Forum Discussion
autofill column only when data are added
I have a column (Column C) that calculates a formula based on the entry in another column (Column B). The spreadsheet will be used by other users. The issue is that I do not know how many entries any...
Do you work with structured table or with range? If the former and wrap the formula wit IFERROR it shall work.
Except I don't want the formula in the cell at all until I enter the data in Column B. I wouldn't think it's possible, but I have an example spreadsheet that does it - I just can't figure out how.