Using a Metrics Sheet to Count Checked Checkboxes Returns One Decimal in Linked Cell


I am using a metrics sheet to count and sum values in columns of a source sheet, and to display the numbers in same column as the entries, in the top row of the source sheet, by using a link to the metrics sheet cell where the counting and summing is occurring.

All works fine except in columns that are formatted as checkboxes. The COUNT function in the metrics sheet works perfect to count boxes checked, but when I link to this count result back to the source sheet (Link for Cell in Other Sheet), it returns the count plus a decimal and a zero, as in if the count is 16, the result displayed in the first row cell of the checkbox column is 16.0

Any ideas how I can truncate this useless (and somewhat confusing) decimal?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Let's try using a formula to create a cross sheet reference and pull it over as a text value.

    =INDEX({Cross sheet reference to single cell}, 1) + ""

    Adding the plus quote quote at the end will convert it to a text string which will hopefully get rid of the decimal. If it doesn't, maybe we can try a ROUND function.

    =ROUND(INDEX({Cross sheet reference to single cell}, 1)) + ""


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!