Count NOT Blank (Joining) + Certain Region

Options

All,

I am creating a formula on a metric sheet to COUNT NOT BLANK columns (range of several) AND if meets a certain region. I tried a few. Any tips?

=COUNTIF(ISBLANK(join{([SALESFORCE Data Error: Late Fee % or Grace Period]}:{[YARDI: Timing Charges Not Billed to Ledger]}, 1, Region@row)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!