Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is not giving me a count,
=count(If(Status_Field='Complete'
and Date1>= date(YearStart(today(0),0,4) )
and Date1< date(YearStart(today(0),1,4)), ID))
Try this way
=count(If(Match( Status_Field,'Complete' ) = 1
and Date1>= date(YearStart(today(0),0,4) )
and Date1< date(YearStart(today(0),1,4)), ID))
Or else share any sample data.
Regards
Anand
Thanks Anand for Reply but I resolved the issue.
Close this thread by flag correct answer of Anand