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!
Solved! Go to Solution.
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
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.
This worked - thanks @DavidSkaife!