Stephanie Taylor’s Profile

Community member since April 2015

points
2136
Company
Harford County Board of Elections
Department
IT & Operations
How I Use Smartsheet
We have placed all of our processes and procedures on Smartsheets. Plus we use Smartsheets for time management and tracking of all projects.

1

Formulas are not my thing.  Can someone help me with a formula to display the following:

If % complete column is 100% turn the ball green in the status column

If % complete column is less then 100%  but greater then 80 turn the ball yellow in the status column

If % complete column is less then 80%

15

I have 20+ sheets with various Due Dates on various rows.  I have a reminder set to send the Preparer a reminder when the Due Date occurs.  Historically, the email notification only shows the rows that are the actual "Due Date".  However, today, it sent the entire sheet and all rows which defeats