Forum Discussion
A complicated IF
If use Excel Tables formulas will be repeated automatically for every new row of the table.
Is there a way for me to adjust the if so when the confidence and training date hasn't been inputted, the cell stays blank? Right now, it's putting in 1/0/1900.
Actually, can i adjust the if so when the training date column is blank, the reassessment date column is also blank?
Please check in attached file
I'd make helper table (in grey) with levels and days to add. It could be in any place of the workbook, preferably in another sheet. With tah we may add named range
and use it for data validation
formula for the Reassignment date could be
=IF([@[Training Date]]="","",[@[Training Date]]+IFNA(INDEX(Confidence[Days],MATCH([@Confidence],Confidence[Confidence Level],0)),0))It returns empty string if Training date is empty, otherwise returns new date. Expanding the table formula will be added automatically.
SergeiBaklan I have attached my attempt at this thing along with the error message I am getting
