Help with Formular with two criteria adding to date value

Nancy K

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!

Kelly Moore

Hey @Nancy K

I think this is what you're asking for

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

Did you mean that if the criteria was not met for the value to be zero? Or did you mean that zero would be added to the [Date Received] value if the criteria was not met? As written the False value returns a zero.

Kelly

Nancy K

@Kelly Moore Thank you! I am hoping it will add 60 days to Date Received if met or leave blank if not.

I just remembered " " is actually blank so I fixed it but I can't seem to get the +60 to work. It is giving me INVALID COLUMN VALUE as the error.

Kelly Moore

Hey

The column type for [Date Received] is a date column, correct? If yes, how is the [Date Received] entered into the sheet?

Kelly

Nancy K

Yes it is a date column. 2 digit month/day/year

Kelly Moore

The column that houses this formula is also a Date column, correct?

Nancy K

@Kelly Moore Thank you so much!!! I swear sometimes its the little things!

Kelly Moore

Lol, yes, you are so right. I'm glad it was something easy to fix.