Empty cells with #invalid operation


I create this formula :

="Q" + ROUNDUP((MONTH([Audit Due Date]@row) / 3)) + " " + YEAR([Audit Due Date]@row)

for Quarters and year automatic entries based on a column named Audit Due Date.

But, when there's no dates on Audit Due Date, then, it appear #invalid operation on Quarters column

I tried to consolidate this IF([Audit Due Date]@row = "", "") but it gives me the same message only in the empty cells. Do you know what I'm doing wrong?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!