Help

Hiding #ERROR! Message from field

Topic Labels: Formulas
425 4
cancel
Showing results for 
Search instead for 
Did you mean: 
ocmac
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:

ocmac_0-1705086236680.pngocmac_1-1705086276656.png

Thank you for any help,

Matt

 

4 Replies 4
almedra
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.
almedra
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)

almedra_0-1705100042043.png

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

 

 

Hey @ocmac!

Here you go:

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