Sign in to join the conversation:
Is there a way to add a conditional format to a cell that has a drop down RYG...like project health? If a task date is past due, I want the health cell to change from green to yellow automatically. Thanks for any help!
Hi Linda,
You can achieve this through a nested IF formula, rather than through conditional formatting.
Here's a Smartsheet blog detailing how to create a nested IF to automate RYG balls: https://www.smartsheet.com/blog/support-tip-automate-RYG-balls
Thank you!
I have one sheet that is tracking PTO where a user has entered the days off. The form allows them to enter a start and end date for their PTO and enters a single record into the sheet. I have a second sheet that I am looking to pull that data into, but there is only one record per person (column in this sheet where the…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
