Calculation from number in a checkbox column

Jacob Slaathaug
edited 12/09/19 in Formulas and Functions

I'm trying to create a column that would allow some groups to report progress as a percentage and some to simply check a box for 100%.

I've written my formula, but as soon as I enter a number within the checkbox column I receive the #Invalid Operation error.

Any help would be appreciated.

=IF(Progress4 = "True", 1 * Duration4, IF(Progress4 = "False", 0, Progress4 * Duration4))

The desired outcome of row 4 would be 8*25%=200%



Invalid Operation checkbox.JPG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!