Sign in to join the conversation:
Is there a way to count the number of rows of text within a cell? I know this will change dependent on column width but if I keep my column width static, I need to know how many rows of text I have within a cell.
Hi,
Interesting! How would you use it?
Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hi community i'm trying to create a formula that calculate a sum in a column based on may criteria. here is a screenshot of the affected column i want to calculate the "volume cumul" (sum of volume collected) based on Week Active should be "This Week" or "Next Week" same Unique ID should be calculated together if Unique ID…
Hi I am trying to work out a percentage for some KPIs. I have a sheet I am recording various KPI entries on (see below) I have a metrics sheet set up so, I can break the KPI results down by month by referencing this sheet. Taking KPI 1 (in the example shown above), I need a formula that will return a percentage of the…
Hi all, Is it possible to display some sort of graphic like this within a dashboard? I'd be taking data from a form and gathering total numbers of of "yes" and "non" questions to get the numerator and denominator for each row or column in the picture. I think I could do the metric sheet part of this task no problem, but…
