How do you get the count of columns used in the sheet?

Bill Spurlock

I am needing to get a the count of number of columns used. It will be used in a calculation.

[Deleted User]

Hi @Bill Spurlock you could use a sheet summary field to count all non-blank values from your range. You'll need to define where the range starts and ends (to my knowledge there's not a dynamic way of doing this, so you'll need to update this if you add more columns)

[Deleted User]

Hi @Bill Spurlock you could use a sheet summary field to count all non-blank values from your range. You'll need to define where the range starts and ends (to my knowledge there's not a dynamic way of doing this, so you'll need to update this if you add more columns)