Nic Larsen’s Profile

Community member since June 2018

points
496

4

I have two columns that I am using, one is a checkbox column, the other is a date column. I want to know, of those that have a checkbox checked in one column, how many of them come after the date 07/01/2019 in the other column. Does anyone know the syntax for that? The column names. The checkbox

3

Hello,

I am trying to create a status of "Adheres" or "Past Due" based of off comparing two date fields (A Target Date and an Actual Date).  When I use this formula I get what I need.

=IF([Target Audit Start Date]8 > [Actual Audit Start Date]8, "Adheres", "Past Due")

 

The issue is that the actual