Variable in DATEONLY formula to allow for a non-date value

I am pulling info from a date column on a project sheet, but in some cases the date value is "N/A" (which is not a date value). I have a secondary colum in my metadata that feeds a portfolio summary sheet. Currently is a formula that is DATEONLY, but I need it to be able to return the "N/A" value instead of "INVALIDDATA". What is the best way to revise this formula?

=DATEONLY(Date@row) + ""

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!