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 created my Smartsheet account yesterday using my Google email (patrick@diamondsolarllc.com). My company is based in the United States, but my account appears to have been created in the EU region (smartsheet.eu). I don’t mind being on the EU region as long as it does not cause issues, but I am currently experiencing the…
Hi Everyone, I'm Soumitra Dutta – Entrepreneur & Photographer Based in Oxford. I’m new to Smartsheet and want to get started using it effectively. Could you share your tips, recommended tutorials, or best practices for beginners? Any advice on how to set up my first sheet or manage projects would be really helpful. Regards…
Missing Form Entry Help Needed. Here's my troubleshooting steps so far: Confirmed Link used is correct and it's entries land on the Form Smartsheet Confirmed no sheet filters or hidden columns Confirmed row entry nowhere on sheet, not on bottom Form shows "3 Submissions"
