Using IF Statement & DATE

I'm trying to combine formulas that if a check box is clicked, it returns the number 7 to me or else it runs a formula for subtracting dates from TODAY but unfortunately I keep getting #INVALID DATA TYPE

=IF(OR(COMPLETE@row, "7"), (TODAY() - DATE@row))

Any help would be great appreciated. Thanks.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!