Formula based on text in another column
Hello, I am trying to get this formula to work but it is returning a #UNPARSEABLE error. Any sugguestions?
Best Answers
-
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, "")
-
Answers
-
@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.
-
@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 " , " ")
-
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-PCG I had an extra space it looks like. Thank you so much :-) I thought I was losing my mind.
-
No problem. And it wasn't the space, it was you were missing an = between the source and criteria.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!