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 very simple task list sheet. No timelines, dependencies, Gantt, %complete - just a list of tasks with status, priority and similar. When I set the Status column to "Complete", I want to (manually) move that row to an archive table with the same column set. A popup box says I need Admin access to move rows. I have…
Are automations set to daily, based on only EOD data or compile all the triggers and send together at EOD? I'm looking for only EOD data and now sure how to get only that in my sheet.
Hello smarties! I hope you all are doing well. I have a new situation that I wanted to start with you all to see how you would handle. I have a new situation where we need to supply a Weekly/Monthly Status Report. I know that I could build this in a dashboard (I also plan to do this) however is there a way to "save" or…
