ISBLANK formula not returning data when cell is blank


I have an automatically generated date column in my sheet 'Created Date'. I want to be able to override this date with a manually entered date 'Manual Date'. I created a new column called 'Inquiry Date' and am using this formula:

=IF(ISBLANK([Manual Date]@row), [Created]@row, [Manual Date]@row)

I want the formula to pull the 'Manual Date' if it exists and if that field is blank, then I want it to pull the 'Created Date'.

This formula works great when the 'Manual Date' has a value, but when it's blank, I get the following error: #INVALID COLULMN VALUE

I'm sure I'm missing something really simple here, but I'm stumped. Any suggestions?

Thanks in advance!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!