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?
Help Article Resources
Check out the Formula Handbook template!