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?
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
I created a new sheet for my team by replicating an older sheet and now my tasks aren't pulling into my task report or any of my teammates. I confirmed the sheet was selected in my report but it still isn't pulling in. I've never had an issue with this before so would love some advice on troubleshooting.
Hi Everyone, I created some forms for our powdercoat test logs. The forms are working great for the employees to input the data. The problem I am having is with giving the supervisors and managers access to the sheet. I gave them Editor Cannot Share permissions to see and edit the sheet. But they are saying that Smartsheet…
