Matching criteria between smartsheets
Not sure this is possible, but here goes! I have multiple smartsheets (let's say 3). Two of the smartsheets collect information from forms that we use to send on to credentialing or contracting so we can load them in our systems. A third smartsheet is a list of line items each with a gap in our network for a provider with a particular specialty and in a specific county. We would love to have some sort of process where the smartsheets could search for open gaps on the 3rd smartsheet that match a line and then check a box or something.
match up open gap "Reporting Category" plus "County" with Specialty in the other two smartsheets and return match or check box if there is a match. (I know we'd have to sync up our column headings)
Help Article Resources
Check out the Formula Handbook template!