Automation before Calculation (Dynamic View)

ker9

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.

 

ker9

I figured out something I could use to send the notice later.

ker9

I figured out something I could use to send the notice later.