The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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: