Hi. I'm trying to make a 'Most Recent Note' field based on a sequence of 'Notes' fields that we'll fill out on a Lead to keep track of activity. I thought I could accomplish this by doing some nested IF functions that checks if the last Notes field is empty, then checks the second to last, and so forth until it finds a field that isn't empty. Once it finds a field that isn't empty it will display the value of that field. Thus it will always show the most recent notes because people will fill them out sequentially. I just have 4 Notes fields for now.

This is my code:

if(Len(${Leads.4th Notes})<2, if(Len(${Leads.3rd Notes})<2, if(Len(${Leads.2nd Notes})<2, if(Len(${Leads.1st Notes})<2,'Nothing Yet',${Leads.1st Notes}),${Leads.2nd Notes}),${Leads.3rd Notes}),${Leads.4th Notes})

I used the Len function because I'm not concrete on how to use 'null'. If there are less than 2 characters in a field I'll consider it effectively empty. It is currently giving me a general syntax error.

Any help appreciated. Thanks!

P.S. The reason we aren't just using the built-in Notes in CRM is because we want to display the 'Most Recent Notes' field in a Report and we only know how to show Fields in Reports.