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:
Hey guys, As per the question title, I'm trying to delete a Level 2 child row itself, indented under a parent When I do this, it deletes all the milestones, project plan data below it :( When I ask Smart Assist, it says it is safe to do so without losing any data - but having done this manually it deletes everything and I…
smartsheet developers, I’ve been using Smartsheet for many many many years and the main complaint from my team is that we cannot on the mobile app. I’m not sure why this is undoable for you guys, but it would be a huge huge of my team in the field if they were able to filter their workload.
Hey Smart Community, Currently I am working in a project which large registration form with nearly 200 questions with 5 category groups. Q 1 to Q15 is common to all Category Q16 to 49 exclusively for Group 1 Q50 to 79 exclusively for Group 2 Q80 to Q115 exclusively for Group 3 Q116 to Q165 exclusively for Group 4 Q166 to…
