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:
@Paul Newcome Yesterday I manually triggered many 'Request for Update' emails by selecting "Run Now" and had no issue. Today, I triggered others and it said it ran successfully but I checked with several people and they did not receive the email. Is there a system issue today?
Recently, (as it used to work), when I follow the Row Actions / Properties / Row Link URL, the URL is overridden. I would follow a link like: https://app.smartsheet.com/sheets/[REDACTED SHEET ID]?rowId=[REDACTED ROW ID] Will convert to: "https://app.smartsheet.com/sheets/[REDACTED SHEET ID]?view=grid" And the screen is…
I have manually triggered the 'Request and Update' > "Run Now" automation to one recipient and he is not getting the Smartsheet email. I have many others who are receiving them. What might be the issue? We have checked his spam and other folders.
