IF Date formula help

System

This discussion was created from comments split from: Flag duplicates based on multiple columns being the same.

alexis.ray89371

I have another case that is similar to this, but I don't think I am doing it right.

It should flag the row IF Date = Today and the Mail Type and Service Center are duplicates. In other words there should only be one mail type per service center per day.

This is the formula I have so far. Any help would be appreciated. Thanks!

=IF(Date@row = TODAY(), COUNTIFS([Mail Type]:[Mail Type], [Mail Type]@row, [Service Center]:[Service Center], [Service Center]@row) > 1, 1, 0)

Ide AirTrunk

=IF(Date@row = TODAY(), IF([Mail Type]@row = [Service Centre]@row, 1, 0), 0)

Type this into the duplicate column on row 1, then right click and make this a column formula.

Ide AirTrunk

Please mark as solved or add Insightful, Vote Up or Awesome if this helped, this helps me!

Andrée Starå

https://community.smartsheet.com/discussion/comment/440278#Comment_440278

Hi,

I hope you're well and safe!

Try something like this.

=IF(Date@row = TODAY(), IF(COUNTIFS([Mail Type]:[Mail Type], [Mail Type]@row, [Service Center]:[Service Center], [Service Center]@row) > 1, 1))

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 comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

alexis.ray89371

Hi! Thank you for responding. I'm well. Hope you are having a good day as well. :)

I don't think it quite gets me all the way there. I was going to test it by purposely adding duplicates. I only got to add one line for today and it already marked it a duplicate.

Andrée Starå

https://community.smartsheet.com/discussion/comment/440423#Comment_440423

Happy to help!

Strange!

Can you paste the exact formula you have in Smartsheet?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

alexis.ray89371

sure thing!

=IF(Date@row = TODAY(), IF(COUNTIFS([Mail Type]:[Mail Type], [Mail Type]@row, [Service Center]:[Service Center], [Service Center]@row) > 1, 1))

Andrée Starå

https://community.smartsheet.com/discussion/comment/440439#Comment_440439

I made a mistake.

Try this instead.

=IF(COUNTIFS(Date:Date, TODAY(), [Mail Type]:[Mail Type], [Mail Type]@row, [Service Center]:[Service Center], [Service Center]@row) > 1, 1)

Did that work?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!