Remove duplicate formula has changed and now need to be corrected.

Options

This is the formula to remove a duplicate that is already on a report:

The number circled in read was not part of the original formula and I don't know why it is there. I have found a duplicate on the report where before all duplicated were being removed. Does anyone know why this has happened and how to correct this?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!