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 have an enterprise license, and a coworker who has a free license needs edit access to my sheet. She cannot edit the sheet despite me sharing. We have tried deleting other sheets that have been shared with her to clear up space, but it does not work (says she does not have permission to delete).
Is there a way to include attachments in automated emails? I want to automate communication to simplify a work process. Currently, emails are sent manually and occasionally contain attachments. All of the information my staff would include in the email is in the sheet, so being able to drag an attachment to a line and then…
Have any of you had a problem with the help button not working? This is the little round button that has a question mark in it. I have tried restarting and refreshing but still nothing happens. I am not getting an error message, it just isn't working.
