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!

Viewers and Permissions after new pricing model
I have provisional users who, under the legacy model, were unlicensed users with editing permissions for workspaces. I’ve now changed their role to "viewers" and assigned editing permissions to specific workspaces, aiming to maintain the same editing experience as before. However, they cannot edit fields within tasks or…
Delete inactive smartsheet account
I'm trying to figure out how to delete an inactive Smartsheet account so I can use that email address for another account. The account I'm trying to delete was a free account with no system admin, so there's no one to contact. The AI bot with the Help Center told me my only option was to use the Smartsheet Community. Any…
Phone number validation won't allow all zeros
Hi- We have been using a SmartSheet Form for a while, and users have been able to enter 000-000-0000 if they don't know a person's phone number. However, over the past few days, it appears that the phone number validation field will not allow all zeros any more. Is there a way that I can change this? We would like the…