-
Formula help please! What formula to mark the parent row "Complete" with an "Not Applicable" task?
In my status column I am using this formula auto update my my parent row: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(), "Not Started") > 0, "In…
-
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…
-
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…
-
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…
-
Duration and Date closed columns auto populate when Date initiated column is filled in
I have "Date Initiated", "Date Closed" and "Turnover Time" columns. The initiated and closed columns will (should) be populated when they happen, but the closed column auto populates to the same date as the date initiated column when it gets filled in. I also had to create a "Predecessor" column which I hid because I don't…