for now i’ve been able to solve this by doing this, but it’s not ideal for me because I need to do a formula to create Custom Field 1 before I can then use another formula to get rid of the error. looking to simplify somehow.
Formula 1 defines Custom Field 1 by grabbing multiple fields based on conditions
Formula 2:
IF({Custom Field 1}=BLANK(),BLANK(),DATETIME_PARSE({Custom Field 1}))