Help with Formular with two criteria adding to date value


I am assisting a team in moving from an excel sheet to Smartsheet. The formula they currently use to perform a calculated function isn't working and I am getting INVALID DATA TYPE as the error. I admit I am not the best formula writer.

Basically if the new row meets he two criteria only then should the cell populate by adding 60 days to the Date Received value.

=IF([Review Type]@row = "Employee Requested", (AND([Current REPR]@row = "OAH", [Date Received]@row + 60, 0))

Thank you for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!