I’d like to show N/A when the field is blank, at the moment I get #Error. Can anyone help with where would I add it into my formula? Here’s what we have so far -
IF(
(IS_AFTER({Hose Inspection Expiry Date}, DATEADD(TODAY(),14,‘days’))=1),
“ :thumbs_...