You could make the REGEX formula @TheTimeSavingCo  provided above conditional on whether or not there is an attachment in your "Display attachment" field.  Try this (adjusting the field names as necessary):IF({Field name}, REGEX_EXTRACT({Field name},...

I think I fixed that last error you found – thanks so much for testing it out so well! Thought I had all of the angles covered, but there were some sneaky instances I didn’t think of which threw wrenches in the works. Fingers crossed – the formula no...

Good catch! I think I fixed it – There was a DATETIME_DIFF() function in there which wasn’t calculating how I thought it would and was throwing that off.

Sure! Sorry for not providing some more context last night – I had to get to bed :yawning_face: First, an update to the formula above to fix a small bug and add some more #ERROR checking: IF(OR({Start Date}=BLANK(), {End Date}=BLANK()), 'Missing o...

See edited formula in the reply below… You could start with this formula, which will work for covering up to 3 years (i.e. 2018, 2019, 2020). Adding additional years would require additional levels to the formula :thumbs_up: