Sign in to join the conversation:
Can you use a sum formula for cells formatted as a symbol? I would like to use a sum formula to add the number of red, yellow, and green status balls.
Hi,
You should use the COUNTIF function instead to count them.
Would that work?
I hope this helps you!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hello, I have a metrics reporting sheet that relies on cross sheet reference formula to count rows from a formula column in a source sheet (let's call it Sheet A) that refreshes with data via data shuttle (set to 'Replace all target sheet rows with the data from the input file') once per day at 8 AM UTC (I am in PST). One…
Dear Community, I have created a form where the contact field is mandatory. If no value is selected in this field, the form correctly shows the error message: “This response is required.” However, if I select a name and then remove it, the field shows a remaining circular icon, and the form gets submitted without any…
I have no idea how to start the program. I need the basics on how to build charts and graphs.
