How can I edit this formula to have a blank End Date field also input Active into the column?

Delilah

=IF([End Date]@row < TODAY(), "Inactive", "Active")

Genevieve P.

Hey @Delilah

Did you try @Andrée Starå's formula?

I did notice there was a potential typo with the "End Date" column reference, so just make sure you replace the column names with your column names:

=IF([End Date]@row = "", "Active", IF([End Date]@row < TODAY(), "Inactive", "Active"))

Andrée Starå

Hi @Delilah

I hope you're well and safe!

Try something like this.

=IF([End Date]@row = "", "Active", IF([End Datef]@row < TODAY(), "Inactive", "Active"))

Did that work?

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!

Delilah

Thank you. I tried it and received a message that the syntax wasn't right.

Andrée Starå

@Delilah

Happy to help!

Can you paste the exact formula you tried?

✅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!

Delilah

Its the one I put in my original question post.

=IF([End Date]@row < TODAY(), "Inactive", "Active")

Genevieve P.

Hey @Delilah

Did you try @Andrée Starå's formula?

I did notice there was a potential typo with the "End Date" column reference, so just make sure you replace the column names with your column names:

=IF([End Date]@row = "", "Active", IF([End Date]@row < TODAY(), "Inactive", "Active"))

Andrée Starå

@Genevieve P.

Ouch! Thanks for catching that!

Genevieve P.

Haha happens to me all the time! 🙂

Delilah

Thank you both. It works now.

Andrée Starå

@Delilah

Excellent!

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!