Trying to return a value using if and statements but get Unparseable so Help?

Saradinen

=IF(AND([Due date 2023]@row > TODAY(), ISBLANK[Completed 2023]@row), "yes", BLANK)

This is the formula which I think is pretty simple but I'm trying to get a yes if the date from due date column is greater than today and information has not been submitted in the completed column.

Feedback is appreciated

Andrée Starå

Hi @Saradinen

I hope you're well and safe!

Try something like this.

=IF(AND([Due Date 2023]@row > TODAY(), [Completed 2023]@row = ""), "yes")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Saradinen

I hope you're well and safe!

Try something like this.

=IF(AND([Due Date 2023]@row > TODAY(), [Completed 2023]@row = ""), "yes")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Saradinen

Thank you thank you!!

Andrée Starå

@Saradinen

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!