How is the checkbox function recognised?

Phil Lomas
edited 12/09/19 in Formulas and Functions

I'm trying to output the number of sick-days into a cell using the criteria 'email address' and checkbox ticked as i only want it to recognise the sickdays if checkbox is ticked. Don't really understand how the checkbox is recognized as I am getting a '#invalid operation'

 

=SUMIFS([Is your absence related to a disability]:[Is your absence related to a disability] =1, [Your email address]:[Your email address], "[email protected]", [Number of sick days]:[Number of sick days])

Can anyone put me on the right path?

 

Thankyou

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!