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 have a urgent matter in needed to restore some deleted data for one of our company VIPs. Our plan only allows us to create tickets online (no calls, email, chat, etc.), but even after days of several tickets being opened, no one has touched them at all, they are all still unassigned. Does anyone know how to get in…
The new Smartsheet UI that has been pushed recently is driving me crazy - i cant find automation anymore It use to be here: I'm going insane - can we go back to the old version? :(
Anybody else hate the new Browse interface, forcing you to click twice to find the browse pane? I suppose it's helpful if you only work on 10 sheets, I have significantly more workspaces and sheets. Not impressed with the new notifications view either.
