Hi Everyone,
I accidentally deleted a column that had a critical formula in it.
I have recreated the column and am trying to show the last date that a step was completed. Below is my formula. I have copied and pasted the column headers to make sure they were the same, but I keep getting invalid column value.
=MAX([Date of Initial R&D Completion]@row , [Date of Sales Completion]@row , [Date of Planning Completion]@row , [Date of Purchasing Complete]@row , [Date of Material Master Completion]@row , [Date R&D BOM Complete]@row , [Date of Production Completion]@row , [Date of Finance Completion]@row , [Date of Pricing Completion]@row , [Date of Quoting Completion]@row )
Any suggestions?
Freda
PS.. I know the titles are different. I didn't create the original sheet and the columns are tied to other formulas. Thanks!