Email Automation Error

[stevenjo57]

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!

[TheTimeSavingCo · Accepted solution]

Can you provide screenshots of your automation setup? 

[stevenjo57]

Thanks for your help!  It seemed to have resolved itself.