If Greater then this Value "Due" unless a date is entered (If Formula or logical expression)

None RBT

Looking for the best way to calculate this. I'm using temporarily conditional formatting to make past "due" as "red".

This form is tracking probationary employees. Logically I haven't figured out how to do this. So when the estimated completed hours is greater then 160 then their 160 evaluation is "past due", unless there is a date in the field. (if a date it means it was completed on that date)

Same thing for each level.

When the [estimated completed hours] is greater then 320 then their [320 evaluation] is "past due", unless there is a date in the field.

When the [estimated completed hours] is greater then 480 then their [480 evaluation] is "past due", unless there is a date in the field.

so on and so on

Thanks in advance

Paul Newcome

If you are trying to populate "Due" into the columns, then it would go something like this...

=IF([Estimated # of Hours Completed]@row > 160, "Due")

The above would go into the [160 Evaluation] column. Just update 160 to the appropriate number for each of the different columns.

rgochee

Set your conditional formats like this

None RBT

I only need past due items to be red. If it sets "blank" to red then it would look like all of the employees are past due. It is based on the number of hours the employee has worked.

rgochee

Fidencia,

Once the Date is entered the Red goes away, the Evaluation is considered "past due", unless there is a date in the field.

Rob

None RBT

this is what I'm working on. Maybe that will help.

Paul Newcome

If you are trying to populate "Due" into the columns, then it would go something like this...

=IF([Estimated # of Hours Completed]@row > 160, "Due")

The above would go into the [160 Evaluation] column. Just update 160 to the appropriate number for each of the different columns.

None RBT

thank you

Paul Newcome

Happy to help! 👍️

Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.