Formula to return a blank if no date shown

Platform discussions Special workflows & use cases
1

Hi All,

I am trying to write a formula for some Docugen Date format columns. My scenario is that I need to use a forumula to alter the date appearance in my Docugen template.

day({Payment date 2}) & “/” & month({Payment date 2}) & “/” & year({Payment date 2})

This works fine, but if the cell in “payment date 2” is blank, I want the formula field to also appear blank. I have tried using IF functions but keep getting errors. Any help would be appreciated!

2

Hi @TPL - Sami here, DocuGen founder. We have similar requests from other users for better support of date columns. Check it out here and add your vote!

3

@TPL

Try this:
FORMAT_DATE({Date},"DD/MM/YYYY")

Jim - The Monday Man (YouTube Channel)
We Create Custom Solutions
Schedule a 1-on-1 Tutorial Session