-
Barcode Help - Scan a barcode and it auto checks a box in Smartsheets
Hi Smartsheet Community! I have a smartsheet where I want to scan a barcode and it auto checks the box as received. The Employee ID column lists the numbers associated with each barcode. The Present column checkbox is what I would like clicked when the barcode is scanned using the Smartsheet mobile app. I know I need to…
-
Formula to count days past a certain date without weekends
Hi! I have a sheet where one column has a submission/end date ("END DATE: CA Exam 4 Part 2") and another column is a "due by" date ("E4 Window Closes"). I have a column that I keep hidden which has that "due by" date ("E4 window closes") to help in the formula I have running: =IF(AND(ISDATE([E4 window closes]@row), [E4…
-
Count if Between a date range
Morning Smartsheet community, Hope you all had a great festive period. I'm struggling with a formula that would make my reports a whole lot easier….. I have a helper column that I want to return a value@row could be anything but for ease say "1", If the date in the [Form Date]@row is between the dates set in [PP Dates]1…
-
Tricky formula!
I receive a report each month that gives me values at the end of each month for a particular group of individuals. See below for the report. The report is delayed so I'll get new numbers for November in December, etc. I need to first report on AUA #'s for that month and then YTD. For example, I'm running numbers for March…
-
Best Formula to use for Validation between 2 Columns in 2 Sheets
Good Day, Looking for some ideas/suggestions for a formula to use to verify values placed in a column in a sheet. In my scenario, I have Sheet 1 and Sheet 2. Within this 2 sheets are 2 columns that need to match. Sheet 1 - Column: 'Product Category' is a manually entered field. This column/field needs to match or flag when…
-
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
-
Count Distinct is Clearly Incorrect.
I have a sheet with approximately 18,000 rows. One column is called "ID". I have a support column where I am trying to understand how many unique entries are in "ID" and I am using this formula: =COUNT(DISTINCT(ID:ID)) It's returning a value of 1 (which is clearly not correct). The column is a text column. There are no…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Need a space saving IF OR formula
I have a working function to assign a school county to a new entry when a certain institution ID is put into the column. My issue, however, is the complete equation to accomplish this is too long and doesn't fit the last few school districts. I'm checking to see if there is a more elegant way to accomplish this so I can…
-
Formatting Column to Display Certain Number of Digits
Hi all! Happy New Year :) Hoping for some help with formatting numbers… For context: Employee ID #s at my company are all 8 digits, so if someone's ID # is 123456, we add leading 0s to the front so it would be "00123456" making all Employee ID #s 8-digits. QUESTION: Is there a format-feature or formula I can use to adjust…
