Help with Formular with two criteria adding to date value

Hello,

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!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!