-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
-
Status Rollup to Parent Formula
Hi, I have this formula that works when automating parent/child tasks in a project plan. =IF(COUNT(CHILDREN(formula@row)) > 0, IF(COUNTIF(CHILDREN(formula@row), "Complete") = COUNT(CHILDREN(formula@row)), "Complete", IF(COUNTIF(CHILDREN(formula@row), "Not Started") = COUNT(CHILDREN(formula@row)), "Not Started", "In…
-
Inventory Check In/Check Out with Forms
Hey Everyone, I'm looking for how to automate a check in/check out process utilizing forms. What I want: Tech fills out form with the item's serial number and checks a box for if they're checking in or checking out This creates a new row in a helper sheet (CHECK OUT) A master inventory sheet (EQUIPMENT) update's the…
-
Formula column that counts the number of rows. Each row having its own number
The issue I am trying to resolve is that when the sheet has 500 rows i want automation to move a number of them elsewhere. lets say i want to move everything numbered from 350- 500. so i need each row to know how many rows there are so i can add automation so over 350 move rows. the problem i am having is i cant use…
-
Formula to Display Top 10 Rows with Lowest Ranking
I have a sheet that captures the average rankings assigned to requests in order of priority. I need a formula to create a metric that displays the Top 10 request IDs that have the lowest average ranking (lowest ranking = highest priority). Here is an example of what I need: The metric needs to be dynamic as the top 10…
-
Count a person from 2 different grids and drop-down vs text box?
Greetings, I'm trying to figure out if there is a way to count a person if they show up in two different sheets with two different selection options. For example, user Amanda Perry could be on sheet 1 listed under the programmer column from a drop-down where the user is only able to select one programmer. User Amanda Perry…
-
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…
-
How can I enter data in a field that has a column formula?
I have a Contact list as a column type on sheet A and it is attached to my feeder sheet B. Sheet A also has a form attached to it and when a list option is selected, the contact list is populated on the sheet. However, if the list option is not selected, then the contact list does not populate. I need to be able to fill in…
-
Column Formula Help - Helper Checkbox for Shift Entries
Hello Community, I am looking for some help with a helper column checkbox formula needed to support reporting of data to a dashboard and downstream formulas. I have four shifts (A,B,C,D) entering data points into a sheet, with the potential for multiple line entries occurring per shift per day worked (see example below). I…
