Skip to main content
hamburger menu
+ Create a topic
Answer

Org Chart data formula to display pay period data in diagram

  • October 31, 2023
  • 4 replies
  • 53 views
Belinda F
Forum|alt.badge.img+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

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!

Comments

Sylvia X
Forum|alt.badge.img+5
  • Sylvia X
  • Lucid support team
  • Answer
  • November 1, 2023

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!

Belinda F
Forum|alt.badge.img+2
  • Belinda F
  • Author
  • November 6, 2023

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.   

Sylvia X
Forum|alt.badge.img+5
  • Sylvia X
  • Lucid support team
  • November 8, 2023

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! 

Micah
Forum|alt.badge.img+20
  • Micah
  • Lucid community team
  • May 6, 2024

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!

 

Level up your skills & unlock exclusive perks!

Join Lucid Legends
Lucid Software Inc. Supplemental Community TermsAccessibility statement

Get Started

Products

Solutions

Resources

Company

Privacy Legal Cookie privacy choices Cookie policy
© 2025  Lucid Software Inc.