Sign in to join the conversation:
Is there a formula that allows me to count the number of columns in a sheet (to include in a sheet summary/)
Hi Jeff,
I might have an idea on how to solve it.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Counting the columns in the sheet would be as simple as adding in two helper columns. One on the far right and one on the far left. We will call the far left [First Column] and the far right [Last Column].
You could then use a formula along the lines of
=COUNTIFS([First Column]1:[Last Column]1, OR(NOT(ISBLANK(@cell)), ISBLANK(@cell))) - 2
.
As long as any columns are added between these two, your count will remain true. Once you have it set up, just hide the columns, and you will be good to go.
As for the Sheet Summary...
This will need to be counted manually. Unfortunately you cannot use Sheet Summary fields as ranges such as
[First Summary Field]#:[Last Summary Field]#.
It would be great if you could though. I personally can think of quite a few cases where this would be helpful.
Feel free to Submit a Product Enhancement Request.
Paul nailed it! That was my idea as well!
Haha. That was another case of us typing at the same time. When I first opened the post, there were no other comments. I do wish that we could use Summary Fields though. The potential uses for that are astounding!
Hi all - found this formula that helps and is amazing … HOWEVER, if any of the cells in the row you are counting contain error from a formula, it breaks the count. It worked like a charm on 4 out of 5 sheets, and then blamo, I got an INVALID VALUE return. Luckily I have a Smartsheet Wizard that I work with and he figured it out!
Not sure yet how to get past the error of the error, but if we figure it out, we'll share it here!
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
I'm officially stumped. I'm tracking Admissions Reps visits to schools, the types of visits and the amount of visits and inquiries. The columns are as follows: Created Date Rep Name Type of Event 1 - Dropdown: Tabletop, College Fair, Classroom Presentation, School Visit, School Tour District 1 - Dropdown with all Districts…
