Can Smartsheet automatically highlight / notify if a reference appears on a sheet more than twice?
I am literally new and learning Smartsheet and have set up a customer order form but each customer can only have a maximum of 2 free orders so i was wondering if it is possible to automatically flag if the same reference appears a third time?
At the moment i am exporting to Excel and using a countif function to check for me
Help Article Resources
Check out the Formula Handbook template!