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?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!