Data type mismatch: format other than LIST or DATE being referenced as a relation

this is the formula

IF Employed? THEN Salary *'EMP03 Employee Drivers by Role'.Bonus % [LOOKUP: 'SYS08 Employee Details'.Role,LOOKUP: 'SYS08 Employee Details'.Department] ELSE 0

Comments

rishabh01

Hey @kebe

Make sure that item you are referencing in your lookup is list formatted. Currently, it is text formatted I believe.

Thanks,

Rishabh.

kebe

you are right, i formatted the role as text while it was a list

rishabh01

Great! You can accept the solution if it worked.

Quick Links

Recent release news

September 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our September 2025 official release notes. The information below offers supplemental information to that post. Planning experience Improved Keyboard navigation across cards Across Boards, Insights, and Worksheets, tab navigation through toolbars in cards and…
Register for our October 29 platform release webinar!
Anaplan's next quarterly platform release webinar will be held October 29, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of…