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:
Hi Smartsheet Community, We're seeing an issue with Dynamic View and wanted to find out whether anyone else has experienced something similar. Scenario We have a workflow where users submit records through forms and then access the records through Dynamic View. Issue The records are successfully created, but some users…
We have a simple text column with no formula. The data is manually changed. But several other sheets read that column or have formulas that use it. For three days in a row, the i have changed the cell from Closed to Cancelled. Everyday i come back the data is changed back to closed. Not sure what is going on.
We have them already grouped and indented, everything shows properly in Card view and the Sheet view but these aren't grouped in the Report view. Any suggestions on how to correct?
