Sign in to join the conversation:
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!
I am attempted to export to excel. I have two different smartsheet documents to export. One of them exported to excel fine, but not the other. This happened a few weeks ago. I make sure all columns were the correct size & no cells were hidden. "We have found a problem with (file) Do you want us to try and recover as much…
Hello Smartsheet Community, I need some help with a report that I created and shared with a customer. The customer is not seeing any of the information that is pulling into the report. See screen shot below that the customer texted me. I do have the report filter only showing the customer their product pulling from our…
BLUF: When I create an Invoice, I need the cell-link to my live price data to be severed. I currently have a Price sheet for my products that is updated frequently. I use Control Center to create Projects, which includes an Invoice sheet. I have a dropdown on my invoice sheet to select a product, and then I use Index…
