Formulae to Smartsheet

edited 12/09/19 in Formulas and Functions

Hi everyone,

I am a new user to smart sheet.  I need to do a sumif calc based on two columns of data being 'unticked' so I want to show the sum of i.e Column D but only if Column A & B remain unticked.  When a cell is ticked it means that the work has been complete etc.

Any help/advise would be greatly appreciated.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!