If and when..

alindberg

The thought process is a have a column with Multiple drop downs. If Service is selcted I would like it to take the date column and add a six month date for followup. The formula I was thinking is:

=IF([What work type was completed?]@row, ="service", Date@row + 180, blank)

However, I must be missing something. UNPARSEABLE lol🤔

Katy H

Apologies @alindberg ! I left in an errant comma. Andrée’s formula should work.

Katy H

Ah, I’m that case try:

=IF(HAS([What work type was completed?]@row, "service"), Date@row + 180, " ")

Katy H

Try this! Just a simple change to make blank work.

=IF([What work type was completed?]@row, ="service", Date@row + 180, "")

alindberg

=IF([What work type was completed?]@row, ="service", Date@row + 180, " ")

I changed it to the above now it says #INCORRECT ARGUMENT.

Could it be because my "what work type was complete" is a drop down with potentially multiple selections

Andrée Starå

Hi @alindberg

I hope you're well and safe!

Try something like this.

=IF([What work type was completed?]@row ="service", Date@row + 180, " ")

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!

Katy H

Apologies @alindberg ! I left in an errant comma. Andrée’s formula should work.

Andrée Starå

@Katy H

Easy to miss!

alindberg

Ok Perfect it Worked! However, One glitch I noticed. The What work type was completed column has a drop down with multiple selections. If service is selected by itself it works, however if it is part of multiple selections it doesn't work. Thank you so much for this so far.

Katy H

Ah, I’m that case try:

=IF(HAS([What work type was completed?]@row, "service"), Date@row + 180, " ")

alindberg

You guys are Stellar!! It works. Thank you so much.

Andrée Starå

@alindberg

Thanks!

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!