Countif on a row of data

Options

Is it possible to count the number of full or blank cells in a ranges of cells, on a single row and have the result in a cell on the row?

I've tried countif and Smartsheet wants to use the full row (@row) that leads to circular referencing.

Best Answer

  • DGS
    DGS ✭✭
    Answer ✓
    Options

    As if by magic, it now works?

    I ended up using SUM( aaa:bbb) that worked, and then changing SUM to COUNTIF and adding the criteria e.g. COUNTIF(AAA:BBB, ="")

Answers

  • DGS
    DGS ✭✭
    Answer ✓
    Options

    As if by magic, it now works?

    I ended up using SUM( aaa:bbb) that worked, and then changing SUM to COUNTIF and adding the criteria e.g. COUNTIF(AAA:BBB, ="")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!