Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Anyone help?
Using formulas, you can automate RYG balls to change colors based on the Due Date being 45, 30, or past the due date?
Thanks
Hello,
Try a formula like the following example:
=IF([Due Date]1 >= TODAY(30), "Red", IF([Due Date]1 >= TODAY(45), "Yellow", "Green"))
NOTE: This is an example formula, please refrain form copying and pasting it straight into your sheet as it may not work. You may need to adjust the formula to better suit your needs and match the correct cell references in your sheet.
Details on creating formulas can be found in our help articles:
I am writing as a Workspace Admin to express significant frustration with the new "Browse Preview" interface. It introduces major workflow regressions that break basic file organization. Specifically, the following core features are broken or severely degraded: Loss of Expandable Workspace Trees: The classic expandable…
The dashboard dropped the editing capability … in addition, I can't move files into the shared workspace … where I am listed as an admin and a paid member.
Hello, I have been noticing that the confirmation email does not send once a user submits a workflow. It was working before and not sure what happened. I don't know where to look besides here.
