FIELDLOOKUP and LOOKUP Formulas do NOT update after data updates

Hi Nick

Thanks for posting in the Community! We'll follow the steps to reproduce that you've provided and follow up with next steps here. 

When we originally created `FIELDLOOKUP` and `LOOKUP`, we hadn’t even begun discussing the ability to edit data, let alone implemented it, so the functions don’t know it’s even possible, let alone accessing the updated data.

We should be able to fix this.

Hi! I’m Micah from Lucid’s community team. 👋 I thought you, and any others who might come across this topic in the future, might be interested in 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!