Hi! Thanks for any help.

Not sure what is causing this. I set up an automation to send an email when a field is updated to a certain value.

The email is sent but the data from the specified fields are not included and there is an error. Here is the email:

-----

Subject: New Potential LCR:  - $ - #ERROR!

This was just added as a planned LCR expenditure.

Estimated Amount: $

Estimated Date: #ERROR!

Vendor:

Vehicle:

-----

So there should be data pulled from the fields for each of items. I also don't know why there is an error.

The data in the actual table records is there and seems OK. Here is what it looks like:

So the data exists, but it's not included, and the estimated date is generating an error. Otherwise the email is being sent.

Thanks for any help!