Ignoring Duplicates
Hi
I added this data mesh to add inspection number based on date of inspection. Now we are getting two inspection for same building(in two different months) , but formula still using the initial month to formulate the Inspection number. is there any other way to ignore that, or am I doing anything wrong?
Answers
-
Hi @Lakshman .
Would it be possible to show more screen captures of your set up and sheets? (But please block out any sensitive data).
It would be really helpful to see an image of the source sheet & the target sheet, identifying what is not being updated or added in. It would also be helpful to see how this Data Mesh is actually configured (tabs 3, 4, and 5 in the configuration).
Thank you!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!