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.
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?
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
@Kristie Diersen
Happy to help!
I saw that Jayesh answered already!
Let me know if I can help with anything else!
Andrée
That is perfect. Thank you!
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
Hi, I'm having an issue where the graphs in the dashboard are auto scaling to the numbers in the table. I was hoping to get a scale of 100 for each of my graphs on my dashboard but there's seem to be no way to update this. Would anyone know how to update this?
Hi, I'm having issues trying to get my automation to function. I have tried it numerous ways and it still doesn't work. Basically, if anything but New York is selected, I want a link email to go out with an additional form I need to fill out. Here is what my workflow looks like: I just cannot figure out what I'm missing…
