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'm guessing this is a no no but we have need to display two different views of our Gantt to our production shops. I've installed and configured the SmartSheet app on their kiosk computers and set them up to view the correct view. The problem is they keep getting blank screens after something (I don't know what triggers…
We have an automated report that sends out once a week using dynamic placeholders in the email automation. everything is working mostly as it should however we cannot figure out how to get one of the placeholders not to copy down the whole email. The placeholders we are using are {{Start Date}} - {{End Date}} {{Agent}} -…
I have two Smartsheet forms (Part A & Part B) which are linked to my intake sheet. This is because there is no option to save the form while completing it so it made sense to split it into two. It may also be completed by different staff members, depending on the information they have available. Both forms have the same…
