Formula based on text in another column

Melanie Sanders

Hello, I am trying to get this formula to work but it is returning a #UNPARSEABLE error. Any sugguestions?

Matt Lynn ACT

@Melanie Sanders

Use the formula below and make sure both the column you're putting the formula in and the RAM LIC CONTACT DATE columns are both formatted as a date column type. Double click the column header to confirm.

=IF([RAM LIC STATUS]@row = "IN TIMELY RENEWAL", [RAM LIC CONTACT DATE]@row - 180, "")

Matt Lynn ACT

Matt Lynn ACT

@Melanie Sanders you need to close the statement. Add " ,"") " to the end or something. You have the true part which is the date minus 180… but you need a comma and a false if it doesn't say that. Either double quotes for nothing or something else.

Melanie Sanders

@Matt Lynn-PCG Thanks for the quick response. I added the statement but it is still giving me the same error.

=IF([RAM LIC STATUS]@row "IN TIMELY RENEWAL", [RAM LIC CONTACT DATE]@row-180," ") "

I also tried but no luck

=IF([RAM LIC STATUS]@row "IN TIMELY RENEWAL", [RAM LIC CONTACT DATE]@row-180," ") &

=IF([RAM LIC STATUS]@row "IN TIMELY RENEWAL", [RAM LIC CONTACT DATE]@row-180 " , " ")

Matt Lynn ACT

@Melanie Sanders

Use the formula below and make sure both the column you're putting the formula in and the RAM LIC CONTACT DATE columns are both formatted as a date column type. Double click the column header to confirm.

=IF([RAM LIC STATUS]@row = "IN TIMELY RENEWAL", [RAM LIC CONTACT DATE]@row - 180, "")

Matt Lynn ACT

Melanie Sanders

@Matt Lynn-PCG I had an extra space it looks like. Thank you so much :-) I thought I was losing my mind.

Matt Lynn ACT

No problem. And it wasn't the space, it was you were missing an = between the source and criteria.