-
Count formula not working with helper column on first sheet, returning all zeros
This is the formula I have =COUNTIFS({Overall Grade}, >=4.5, {Fleet}, "717", {Mod Helper}, "100") On the main sheet, there is a helper column which converts the module number to a set 3 digit number (i.e. 102, 141 helper column will show 100) No matter which return the helper column has, all return zero.
-
Reference or copy a column in one sheet to another sheet automatically
Hi, I am trying to figure out a way to automatically get specific columns in one sheet, into another sheet I was originally looking at using a workflow to copy the rows over, but I only wanted to copy a subset of the columns which doesn't look to be possible. Then I started looking at cross-sheet references, but the posts…
-
SUM FORMULA BASED ON MULTIPLE CRITERIA
Help PLEASE!!! I am looking for a formula that will sum the total travel cost of resources, if selected, based on the qty of each resource and also the resource rate (from another data sheet). For this example I have 3 travel items: Line 1: I have 3 resources which will be traveling, project manager, design engineer and a…
-
Formula To Count The Number of Days an Incident Occurred
I am building a safety event submission sheet and I wanted to add some metrics to a dashboard. If an event is submitted, that day is considered a "Red" day and if no events were submitted it is a "Green" day. The goal is to make a chart that shows number of red days out of the month. A day will be considered red regardless…
-
Form dropdown options pulled from another sheet
Hi! I would like to make a form with the options pulled from another sheet. This is to prevent an incorrect project code being entered. The column drop-down options would need to be a the list of project codes from another sheet. The drop-down options would need to update continually as new project codes are added to the…
-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…
-
Different Dates on the one sheet
I am in Victoria, Australia and I am using a form to populate a sheet. I want to automatically populate the Inspection Date to be the date the row was created. I am using the formula =created@row The Created date, being the system generated date is correct, but as you can see the Inspection date using the above formula is…
-
Have a column with different values and trying to create helper column to assign number
Have a column where freeform module numbers are entered (i.e. 101, 204, 300, S811). I want to create a helper column, where it will read the module number and assign a single digit. (i.e. 101, 104, 141, will all return "1" in the helper column and so on)
-
Check A Box When A Value On Another Sheet Changes
I have a sheet that is pulling data from a second sheet. What I want to happen is when the status changes to RECEIVING COMPLETE on the second sheet, it checks the box in the received into stock column. The problem is that once that status is updated to that value on the second sheet, it's moved onto an archive sheet that…
-
IF formula for INDEX/MATCH across sheets
Hi, I'm really struggling with this one. I have a sheet that has a drop-down with options for "Yes" and "No" and I want to perform an INDEX/MATCH function based on another cell in that row, but only if the result of the drop-down in that row is Yes. The sheet reference for the Yes/No drop down is {App_S}, and the two cells…