Matching Daily Attendance to a Master List of Badge Numbers

Hello,

I am attempting to convert a Conditional Formatting formula from Excel into a smartsheet by using a Helper column.

If a badge is scanned, I want the number to populate in a "Daily Scans" column, then I want to match that against a Master List of Badge numbers "Badge Numbers"

My Helper column formula is: =IF([Daily Scans]@row = [Badge Number]:[Badge Number], "Green") but I receive an #INVALID OPERATION in my Helper column.

My original Excel conditional formatting formula is =COUNTIF($C$C, $B1)>0 where C is the "Daily Scans" and B is the Badge Number.

Any input would be appreciated.

Thanks.

Find more posts tagged with

Accepted answers

All comments

James Keuning

I am not 100% sure what you are trying to accomplish, but I think you can use COUNTIFS.

=IF(COUNTIFS([Badge Number]:[Badge Number], [Daily Scans]@row) >= 1, "green")

Seth Hennes

Thanks for the response. The goal is to highlight those Employees who are in attendance for the day.

The Columns are:

Name Badge Number Daily Scan

Jon 12345 00001

Sally 54321

Tom 00001

The Daily Scan column would be populated by a USB barcode scanner and would fill up as employees arrive. When a scanned badge matches any Badge Number in the Column then the name would highlight indicating that “Tom” was in attendance (in the above example).

I am able to do this in Excel, I’m just not familiar enough with Smartsheets to translate the conditional formatting

Thanks,

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.