Question about Monthly Planner and Calendar Template

[JJBoy]

Hi,

First of all, thank you for offering a great product for free. I appreciate all the work going into this calendar template.

I want to modify this template to my need. Instead of displaying icons and activities on the Printable 12 month, I would like to display a number value I assigned to each icon type. For example, Home Stuff has a value of 10, and Work Stuff has a value of 5. Here is what I’v done so far:

1. Created a new column on the Icon Options table and name it Units
2. In cell Calc!AJ29, I type the following formula:
=MAP(AJ13#,LAMBDA(a, IFERROR(LET(units, XLOOKUP(FILTER(Plan[Type],Plan[Date]=a,"x"), icons[Type], icons[Units]), units),"")))

But the formula returns a #Calc error. What am I missing?

Edit: I should add that if I use the following formula, it works just fine:
=MAP(AJ13#,LAMBDA(a, IFERROR(LET(units, XLOOKUP(FILTER(Plan[Type],Plan[Date]=a,"x"), icons[Type], icons[Units]), TEXTJOIN(CHAR(10),TRUE,units)),"")))

All the values in the Units column were formatted as numbers.

Thanks in advance for your help.

 

[AliGW]

Please attach the workbook.

 

[JJBoy]

Thanks for responding. Here's my test file.

My modified formula is actually in Calc!AJ21, not AJ29.

Thanks.