0s on my charts

Comments

Paul Newcome Community Champion

12/12/22

@FWPBIDev There is a solution here. A relatively straightforward one at that. You write your formula so that it only outputs the number if it is not zero.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
1 · Share on Facebook Share on Twitter
FWPBIDev ✭✭✭

12/12/22

Ugh, so simple! Thank you very much. Really appreciate it.

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

auto-resend update (or approval) request after 30 days
I have some automations set up where the work is intensive (or people forget) and update (or approval) requests sit for more than 30 days. The notification center wipes these requests out after 30 days and although they sit in email, people seem more likely to completely forget about these completely. Does anyone know a…
Adding Contacts To Contact Columns
In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for "sharing". I want to share sheets with my whole operation (75+ people), but having to individually…
Sending Alert Email based on Contact Column without sharing sheet
I would like to create an Automation to send an email regularly to recipients that are in a Contact column based on some criteria. After setting up the Alert Email it says that I must share the sheet with these people in order for them to receive it. The email contains no information from the sheet other than getting their…

Help shape the future of Smartsheet.
Share your ideas and feature requests.