Grouping into Date Fields

[kaylagross12]

Hello, 

I am working on building out a workflow for survey data that we refresh quarterly. I have a refresh date field that is being used to allow individuals to filter by most current data. Is there anyway that I can add a refresh date for records that are blank but keep those that already have a refresh date? For example, I want those Refresh Date fields that are blank to be November 2022 but I want the Refresh Dates that are "March 2022" and "July 2022" to remain as is.

Thanks in advance!

[DavidSkaife · Accepted solution]

Hi @kaylagross12 

A simple formula like the below will work:

IF IsEmpty([Refresh Dates]) THEN "November 2022"
ELSE [Refresh Dates]
ENDIF

The IsEmpty checks for nulls and empty fields, and the November 2022 part can be replaced with a DateTime calculation to dynamically date stamp it if required

[JosephSerpis]

Hi @kaylagross12 you could do this a number of ways one would be with a conditonal or IF formula within a formula tool using ISNull or Ismpty to test is your filed is empty and then replacing it with a value.

[kaylagross12]

This worked - thanks @DavidSkaife!