Sign in to join the conversation:
Is there a way to exclude cells that have a zero from charting? The bar chart does not show any data, but the topic headers, that have a zero, are cluttering the legend. If there is no data >0, I really would like the legend to not show the headers.
I generally use an IF statement for this...
IF(original formula > 0, original formula, "")
This says that if the returned result from my formula is greater than zero, display the returned result, otherwise leave blank.
I did this and the formula worked, but my chart widget in the dashboard is still displaying the blanks. Any ideas?
Hello, I have two sheets. One is "Current tasks" and one is "Completed tasks". I have the rows (individual tasks) auto number when entered (2026-001, 2026-002, etc.). When the row is marked complete, it is moved to the "Completed task" sheet. The problem I am having is that when the row is moved the other tasks that remain…
Its very frustrating when you are adding multiple columns and having to use the slide bar to move to the end and then click the 3 dots and add another column. Seems there has to be an easier more productive way.
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
