Automation before Calculation (Dynamic View)
Based on testing, automation is happening before cross reference calculation has completed.
Rows are added through Dynamic View (DV).
After a new row was added through DV, the calculated field (cross reference) was #INVALID. After 1-3 seconds it appeared correctly.
Creating a new row directly on the sheet calculated faster and automation worked as it should.
I don't know if calculation is always slower or randomly slower.
Any suggestions for overcoming Automation triggered on Row Added happening prior to calculation?
DataMesh is even slower than the Cross Reference.
ETA: The cross reference is an email address that is used by automation.
Thank you.
Best Answer
-
I figured out something I could use to send the notice later.
Answers
-
I figured out something I could use to send the notice later.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives