topic Formula to ignore filled cells and only run on the blank ones in a column in Alteryx Designer Desktop Discussions

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

ddelao95 — Fri, 10 Sep 2021 16:06:17 GMT

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!

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

dougperez — Fri, 10 Sep 2021 16:18:45 GMT

This helps you?

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

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

csmith11 — Fri, 10 Sep 2021 16:53:55 GMT

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.

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

ddelao95 — Fri, 10 Sep 2021 17:36:38 GMT

Thank you almighty gurus 👨‍🚀

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

atcodedog05 — Fri, 10 Sep 2021 17:39:04 GMT

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 🙂