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.
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!
Anyway we can make this view only for security purposes? We would like to prevent users from sending responses to other users by accident.
I am currently setting up an automation for people to get notified through their email, when they are prompted. But is there a way that they can reply in the email of a comment that will then go to the specific sheet. This way they do not have access to the sheet, but can just comment through email with updates?
I am extremely frustrated and disappointed with my current Smartsheet experience. I have paid for a Pro subscription, I am the owner and administrator of my account and sheets, and I have confirmed I am logged into the correct account. Despite this, Smartsheet is not recognizing my Pro subscription, and I am unable to…
