The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
I’m trying to write a simple IF statement in the CM Maturity Date column comparing the Policy Type field and outputting either a DATEADD function, if “Claims Made”, or a text string (“N/A”) if “Occurrence”:
This is the formula that I currently have ...
I fixed the quotes, which took care of the error, but I’m still only getting the N/A in every row, even for Claims Made policy types. It’s like it sees all the policy type entries as Occurrence.