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:
