Formula error help: Not Started, Complete, In Progress, Overdue

CAPM_JBibb

Hello - Looking for assistance to resolve #INCORRECT ARGUMENT SET error.

I believe I am overlooking it, because I have been focused on it for too long.

If the due date is in the future, I want "Not Started"

Formula giving error:

=IF([% Completion]@row = 1, "Complete", IF(AND([% Completion]@row < 1, [Due Date]@row < TODAY(0)), "Overdue", IF(AND([% Completion]@row < 1, [Due Date]@row > TODAY(0)), "Not Started"), "In Progress"))

_______________________________________________________________________

The below formula makes everything "In Progress" if not complete or Overdue and I want to add argument for "Not Started"

=IF([% Completion]@row = 1, "Complete", IF(AND([% Completion]@row < 1, [Due Date]@row < TODAY(0)), "Overdue", "In Progress"))

Appreciate another set of eyes to help.

Dave Stanley

@CAPM_JBibb I think @Rodolfo Garcia is on the correct path and that does fix your current formula in terms of errors. I do think, however, that you have potentially missed two scenarios. The following is broken down by dates in the past, today and dates in the future. For "today" (the green section) if the % Completion is 0% it displays as in progress, I would think that would still be Not Started. And for tomorrow, if the % Completion is greater than 0% it still would show as Not Started even though it has been started.

Change the formula to this:

=IF([% Completion]@row >= 1, "Completed", IF(AND([Due Date]@row >= TODAY(), [% Completion]@row > 0), "In Progress", IF(AND([% Completion]@row < 1, [Due Date]@row < TODAY()), "Overdue", "Not Started")))

Now the results would reflect as follows:

Mike TV

@CAPM_JBibb

=IF([% Completion]@row = 1, "Complete", IF(AND([% Completion]@row < 1, [Due Date]@row < TODAY(0)), "Overdue", IF(AND([% Completion]@row < 1, [Due Date]@row > TODAY(0)), "Not Started", "In Progress")))

I believe the only thing I corrected was removing the ) after the "Not Started"

Rodolfo Garcia

Hello Bibb

I try to find this solution

I hope it helps

Regards

Rodolfo Garcia

Rodolfo Garcia

@CAPM_JBibb

Dave Stanley

@CAPM_JBibb I think @Rodolfo Garcia is on the correct path and that does fix your current formula in terms of errors. I do think, however, that you have potentially missed two scenarios. The following is broken down by dates in the past, today and dates in the future. For "today" (the green section) if the % Completion is 0% it displays as in progress, I would think that would still be Not Started. And for tomorrow, if the % Completion is greater than 0% it still would show as Not Started even though it has been started.

Change the formula to this:

=IF([% Completion]@row >= 1, "Completed", IF(AND([Due Date]@row >= TODAY(), [% Completion]@row > 0), "In Progress", IF(AND([% Completion]@row < 1, [Due Date]@row < TODAY()), "Overdue", "Not Started")))

Now the results would reflect as follows:

CAPM_JBibb

Thank you for the assistance all of you

@Dave Stanley you hit the nail on the head - that worked perfectly. I knew I was missing something and needed a fresh view. Thanks🙂