Help with formula to check box based on specific criterion

jmo

Hi team - need your help.

I have a formula that computes the actual day between 2 dates (using NETWORKDAY) which returns a number in that column cell (days count).

I have a "helper" check box column next to that column cell that I need checked if the actual days is equal to or less than 10 days AND not 0 (or blank).

I've tried =IFERROR(IF([days counts]@row >0 =< 10, 1, 0),"") but it doesn't work nor does this throw an error (unparsable, etc)

Any ideas on how to go about this formula?

Thanks,

Jeff

Paul Newcome

You would need something more like this:

=IF(AND([days counts]@row>0, [days counts]@row<= 10), 1)

Paul Newcome

You would need something more like this:

=IF(AND([days counts]@row>0, [days counts]@row<= 10), 1)

jmo

@Paul Newcome - once again you come through!

Appreciate the assistance.

Paul Newcome

Happy to help. 👍️