Is it possible to set up conditional formatting to alert when a duplicate entry is inputted?

Is it possible to set up conditional formatting to highlight or alert someone if a duplicate entry is being inputted?

I am looking to highlight the DOC ID if it has previously been entered into the sheet.

Find more posts tagged with

functionality

Hi Kristie,

It’s not possible with a conditional formatting alone, but in combination with a formula it can be done.

Would that work?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Andree,

How would this work with a formula? What kind of formula would be used for this?

Hi Kristie,

You will need to create a new column (I;m going to call it Duplicate), make it a checkbox type and apply this formula to it

=IF(ISBLANK([DOC ID]@row) = false, IF(COUNTIF([DOC ID]:[DOC ID], [DOC ID]@row) > 1, true), false)

Now for highlighting part:

Set a conditional formatting that - If Duplicate is checked, then apply this(your choice) format to the row.

Similarly for a alert - When Duplicate is checked send an alert.

Hope it helps!

Thanks,

Jayesh

Happy to help!

I saw that Jayesh answered already!

Let me know if I can help with anything else!

Best,

Andrée

That is perfect. Thank you!

Folder Level Sharing
Circling back to this….. Another year goes by and still no folder level sharing. Smartsheet developers don't listen to their clients. I have seen hundreds or posts and requests for this over the past 7-8 years. And still NOTHING!! This has been a huge issue for us as a company. As you can tell this is a sore spot for us…
Restore multiple cell changes from Snapshot
Today a team member accidentally changed several rows by either deleting the data or the row itself. Do I download a snapshot of each one to restore? Some of them didn't seem to be too helpful. What is the protocol for restoring this information? I've only done this before with the help of a representative and it was…
Why are my answers not showing up when a document is generated?
I have my Smartsheet set to generate a document when a form is filled out. The document is a fillable PDF and when the document generates not all of the answers populate on the generated PDF. I have tried making the PDF again from scratch, I have tried copying and pasting the fields so I know they're the exact same…