Formula for Automatic Date Entry
I have 2 columns to be used in this formula:
One is for the Date Completed in Date Format, and the other is the task Completed checkbox column.
I would like to create a formula that automatically enters the date as Today's Date in the Date Completed column if it is empty, and the Checkbox is checked.
I've tried to do this, but I get #INCORRECT ARGUMENT SET
It is in the Date Completed column: =IF(ISBLANK(), IF(Completed6 = 1), TODAY())
Am I on the right track?
Help Article Resources
Check out the Formula Handbook template!