nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

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

Kristie Diersen

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

Conditional Formatting

Comments

Andrée Starå

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

Kristie Diersen

Andree,

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

Jayesh Nathani

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

Andrée Starå

@Kristie Diersen

Happy to help!

I saw that Jayesh answered already!

Let me know if I can help with anything else!

Best,

Andrée

Kristie Diersen

That is perfect. Thank you!

Sign in to join the conversation!

Quick Links

Trending discussions

Autos to move row to new sheet - STUCK!
Hello, smarter friends: I'm trying to learn how to utilize automations to move certain rows to new sheets in order to explore if my larger/longer ranging goal is possible. Where I'm Currently Stuck: I can't even figure out how to create functional auto to send a row to a basic sheet. That is my immediate need. But if…
Connectivity Issue
I'm having issues accessing Smartsheet in both the desktop app and web browser and continually get the below error message…I need to refresh multiple times to get it to work. And sometimes it works and sometimes it doesnt:
Can no longer edit Smartsheet that I own.
This just started today… For some reason, I can no longer edit fields in my Smartsheet. One I'm the owner of. I do see an icon in the upper right that says "Comment Only", but can't figure out how to change it. Here a screenshot of what I am seeing: