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:
Recently i have been seeing "Form Unavailable" show up on Forms taht have worked without issues for ages. I thought it might be connected to Table View, but I am not sure for certain. One is on a newly created form and the other is on a sheet that I converted to Table view, because we were hitting the 500K cell limit (so…
Hello community, What can we do if I cannot delete the data shuttle workflows that I created myself? Thanks!
Hello, I have created a dashboard and added some Metric Widgets to my dashboard that is pulling text from the profile data sheet that I created. However, on the screen shot below, where it is pulling information into, I want to change the formatting (no bold, smaller font). But when building the dashboard, it doesn't let…
