Hiding #ERROR! Message from field

[ocmac]

Hello all,

Hope you all had a good holiday season.

I have looked, but can't find anything around this, which I think is simple.  Most of what I am seeing on here looks more complicated than it should be.

I have a Date Formula field that I would like to populate with Today's date if a box is checked.  I can get that part working, but the rest of the fields show the #ERROR! message.  I just want to hid the message and show nothing.

This is what I currently have:

Thank you for any help,

Matt

[almedra]

Hi Matt, I usually use IF(AND()) to check if the columns I am trying to review have content in them. For example:

IF(AND({Float Request Sent}),DATETIME_FORMAT(TODAY(),'MM/DD/YYYY'))
I hope this helps troubleshoot your formula field! Please let me know if you have any other questions.

[almedra]

That Solution that I Give you in the previous post, works but the thing is that if you check the database tomorrow it would have the tomorrows date. What I Suggest is to create a column that identifies when the Float Request Sent was modified (Last Modified Field)

and them create an automation. I have attached the whole process in the attachment sections.

[Ben_Young1 · Accepted solution]

Hey @ocmac!

Here you go:

IF(
    {Float Request Sent},
    DATETIME_FORMAT(
        TODAY(),
        "MM/DD/YYYY"
    )
)

[kuovonne]

https://support.airtable.com/docs/common-formula-errors-and-how-to-fix-them