Get a status by needing 5 dates filled out

Please help

Hi,

So i need a status column after the last date column here that says complete when all the dates are filled in or pending when only 1,2,3, or 4 dates are put in.

Samuel Mueller

@Please help Something like this

=if(count([Date Certified...]@row:[Date Entered into Event...]@row)=5,"Complete", "Pending")

or

=if(count([Date Certified...]@row:[Date Entered into Event...]@row)=0,"Not Started", if(count([Date Certified...]@row:[Date Entered into Event...]@row)=5,"Complete", "Pending"))

Fill out the ellipses with the actual column names.

Samuel Mueller

@Please help Something like this

=if(count([Date Certified...]@row:[Date Entered into Event...]@row)=5,"Complete", "Pending")

or

=if(count([Date Certified...]@row:[Date Entered into Event...]@row)=0,"Not Started", if(count([Date Certified...]@row:[Date Entered into Event...]@row)=5,"Complete", "Pending"))

Fill out the ellipses with the actual column names.