Skip to main content
Solved

Hiding #ERROR! Message from field

  • January 12, 2024
  • 4 replies
  • 70 views
ocmac
Forum|alt.badge.img+5

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

 

Best answer by Ben_Young1

Hey @ocmac!

Here you go:

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

 

4 replies

A
Forum|alt.badge.img+3
  • almedra
  • New Participant
  • January 12, 2024

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.
A
Forum|alt.badge.img+3
  • almedra
  • New Participant
  • January 12, 2024

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
Forum|alt.badge.img+22
  • Ben_Young1
  • Brainy
  • Answer
  • January 13, 2024

Hey @ocmac!

Here you go:

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

 

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • January 13, 2024

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

 

Ben_Young1
Terms & ConditionsAccessibility statement