Org Chart data formula to display pay period data in diagram

  • 31 October 2023
  • 4 replies

Badge +2

I'm attempting to create a formula which displays the relevant pay period for our org chart data (e.g. - as at PPED 3 November 2023) in a standard shape as part of the page header.  The Pay Period field is included in the org chart data for each record.   I've tried to use the LOOKUPVALUE formula but keep getting an error at the start of the formula whether I use the '=' or '{{= ' syntax.   e.g. 

=FIELDLOOKUP("Sheet1""Pay Period End Date""74603020")


The key is the top level position in the data.    Is this possible to do or am I using the incorrect formula/syntax?


Best answer by Sylvia X 1 November 2023, 01:42

View original


Userlevel 2
Badge +3

Hi Belinda thanks for posting in the Lucid Developers community! This seems to be related to a bug we have identified when the key is an integer with quotation marks. I was able to reproduce this behaviour and I have reported this to our relevant team. I will update this thread as soon as this has been fixed.

In the meantime would you mind removing the quotation marks around the integer value to see if the error still occurs? If you're still receiving an error I recommend you check that your Org chart data collection name matches what you have in your formula. 

Thank you in advance for your help and patience! I'm sorry for any inconvenience this may cause. Please don't hesitate to let us know if you have any other questions!

Badge +2

Removing the quotation marks from the Integer makes sense however the formula is still not working.   Am I correctly referencing the data source?    Attached is a sample of the data source used to build the org charts.   

Userlevel 2
Badge +3

Hi Belinda

Thanks for following up here! It seems that you submitted a support ticket for this issue and we have followed up there. I recommend you refer to your email for further communication. Thanks! 

Userlevel 6
Badge +17

Hi! I’m Micah from Lucid’s community team. 👋 Jumping in here to share about Lucid’s Data Trusted User Group. This group is made up of knowledgeable users who regularly analyze and visualize data in their work. As part of this group, you’ll have the opportunity to connect directly with Lucid’s product team, gain early access to beta features, and share insights about your needs, shaping the future of Lucid’s data solutions 🎉 You can learn more and request to join here. Thanks!