Comparing cells in two columns

I need to compare two date columns. If Column A contains a Date and if column B does not contain a date then count, otherwise 0. I have tried =IF(ISBLANK([Date CMI filed in compliance]@row), IF(NOT(ISBLANK([Date form sent to FE]@row), 1, 0))) but it is returning an incorrect argument, can anyone help me please?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!