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 all - I have a report that includes a symbol column type. The report is displaying the column correctly (with the symbol). However when I create a Dynamic View from this report, instead of that column displaying symbols, it displays text. Is there a way to get symbols to display in Dynamic view?
Does Smartsheet have the capability to create business process flowcharts or process documents? Im looking for something similar to Vizio or lucid chart?
My manager has asked me to put a border around all of my metric widgets in my dashboard. I cannot figure a way to do this. I tried creating a jpg. of an unfilled rectangle and bring in as an image. But I could not get the widgets to stay on top of the reectangle. Any ideas?
