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'm seeing this error for the first time as I expand some capability in an existing workflow. Here's how this section with the error works. Scenario: a user puts in a request on the form with a check box indicating they will later upload the required file attachment. Automation sends a request for Approval with…
I have a task that started in Sept and ends in Feb. I need to assign it to someone else, but do not want to lose the history of the first employee. How do I do this?
Starting a couple of days ago, I started getting 2 or more emails a day about my account being activated. I have a monthly subscription but have never received this type of email from Smartsheet. The email looks legitimate - the sender is "reply_to@Smartsheet .com" - except for maybe the greeting, which is "Dear Customer".…
