NaN/NaN/NaN result in Formula

Platform discussions Special workflows & use cases
,
1

When using template program DocuGen we needed to create a formula so dates would show in the US format: MONTH({Date of Exam}) & “/” & DAY({Date of Exam}) & “/” & YEAR({Date of Exam}). However if the date column is empty it comes over as NaN/NaN/NaN I’ve done some digging and couldn’t find a way to rename this something else if blank for Dates. I’ve tried a few including TEXT at the beginning but it didn’t work. Does anyone have a suggestion? @JCorrell
image

2

@Rach12

Here’s one way:
FORMAT_DATE({Date of Exam},"MM/DD/YYYY")

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like
3

Wonderful! This is better than my previous formula, and it leaves the blank columns blank, as it should! Also translates perfectly on the template. Thank you!
image