ISBLANK formula not returning data when cell is blank

Options

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!