IF Formula

Debbie Magee

This is my first time creating an IF formula. I think it should be easy for someone who knows what they are doing, so I hope you can help me.

I'm trying to compare two date columns. If both columns have the same date, it should return 'SAME", if they're different dates, it should return "DIFFERENT".

Could someone please help me?

Thanks

Dan W

You would=IF([DEMARC Extension Work Scheduled (Date)]@row = [DEMARC Extension Alternate Date Proposed]@row, "Same", "Different") replace

Andrée Starå

Hi @Debbie Magee

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to 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!

Dan W

Would something like this work for you?

=IF([Date 1]@row = [Date 2]@row, "Same", "Different")

Debbie Magee

Thanks Andre. The screenshot is below.

I'm trying to compare the dates in the DEMARC Extension Work Scheduled (Date) and DEMARC Extension Alternate Date Proposed. Long story short, if a formula can be created to provide the response (same/different), I can then create an automation that will request the customer to review and approve the Alternate Proposed date, if different. Now, if the columns are the same, then no alert would be generated.

Debbie Magee

Hi @Dan W,

For the formula you posted (=IF([Date 1]@row = [Date 2]@row, "Same", "Different")), how would it look with the column headings?

The column headings are DEMARC Extension Work Scheduled (Date) and DEMARC Extension Alternate Date Proposed.

Dan W

You would=IF([DEMARC Extension Work Scheduled (Date)]@row = [DEMARC Extension Alternate Date Proposed]@row, "Same", "Different") replace

Debbie Magee

@Dan W, that worked. I had to remove (Date) from the DEMARC Extension Work Scheduled (Date) column, but it worked!!!! Thank you so much!

Dan W

@Debbie Magee Excellent glad I could help!

Debbie Magee

@Dan W, I just realized I missed something. I think a step is needed in the formula so if neither column has a date or only one of them has a date, there will be no response. I hope that makes sense.

Dan W

=IF(OR([DEMARC Extension Work Scheduled]@row = "", [DEMARC Extension Alternate Date Proposed]@row = ""), "", IF([DEMARC Extension Work Scheduled]@row = [DEMARC Extension Alternate Date Proposed]@row, "Same", "Different"))

Debbie Magee

Thanks @Dan W, that provided what I was looking for. Have a great day!