IF Formula
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
Best Answer
-
You would=IF([DEMARC Extension Work Scheduled (Date)]@row = [DEMARC Extension Alternate Date Proposed]@row, "Same", "Different") replace
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Would something like this work for you?
=IF([Date 1]@row = [Date 2]@row, "Same", "Different")
-
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.
-
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.
-
You would=IF([DEMARC Extension Work Scheduled (Date)]@row = [DEMARC Extension Alternate Date Proposed]@row, "Same", "Different") replace
-
@Dan W, that worked. I had to remove (Date) from the DEMARC Extension Work Scheduled (Date) column, but it worked!!!! Thank you so much!
-
@Debbie Magee Excellent glad I could help!
-
@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.
-
=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"))
-
Thanks @Dan W, that provided what I was looking for. Have a great day!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!