Formula to ignore filled cells and only run on the blank ones in a column

[ddelao95]

Hello Alteryx Community

I bring my humble question which is how to create a formula in Alteryx to fill in the date that I run my weekly report.  But I wanted to mitigate the possibility of me running it twice in a week and it overriding my previous formula of DateTimeNow() and updating the date.  Which brings me to want to turn it into an If formula to still do the same thing, but ignore the column if it's already filled.  Does anyone have any suggestions?

Any insight is appreciated!

[dougperez · Accepted solution]

This helps you?

If isnull(COLUMN) then datetimenow() else COLUMN endif

[csmith11 · Accepted solution]

Same answer as above, just wanted to show you this in a formula tool as well since its a little more clear.

You'll want to make sure you have the data type set to date if you are looking for just the date, or set it to datetime if you want to include the time.

[ddelao95]

Thank you almighty gurus 👨‍🚀

[atcodedog05]

Solution authors are Happy to help : ) @ddelao95 

If the solution author's response helps please don't forget to mark it as a solution.

Cheers and have a nice day 🙂