Re: Hiding #ERROR! Message from field

465 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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,



4 Replies 4
4 - Data Explorer
4 - Data Explorer

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'))Example.PNG
I hope this helps troubleshoot your formula field! Please let me know if you have any other questions.
4 - Data Explorer
4 - Data Explorer

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.



Hey @ocmac!

Here you go:

    {Float Request Sent},