-
index / collect questions...
I'm trying to figure out how to find the last update in a column. The column does not always get updated when other columns do. I saw some similar looking formulas like =INDEX([Date/Time]2:Location10, MAX(COLLECT([Date/Time]2:[Date/Time]10, Location2:Location10, <>"")), 7) but they don't seem to work for me - i get invalid…
-
Track inventory movement in multiple warehouse locations
Hi, We would like to track inventory movement between multiple warehouse locations, there is no need to track stock value/sales, just need to track inventory movement between locations and the inventory balance Warehouse: Warehouse A, Warehouse B Item: Item A, Item B Current Stock: - Warehouse A, Item A: 15 - Warehouse A,…
-
Formula to match two column inputs within one row in two separate Smartsheet's.
Roster Smartsheet: Course Email Eval Completed Class1 Joe@email.com =formula here Class1 Jane@email.com =formula here Class2 Joe@email.com =formula here Evaluation Smartsheet: Course Email Class1 Joe@email.com Class1 Jane@email.com Class2 Joe@email.com Formula that doesn't work:…
-
Formula help - reference data from 2nd sheet, with conditions
Hi, I’m looking for help with a formula for my sheet. Images of my sheets are below Goal: I want to auto-populate the Holiday column in Sheet 1 with data from Sheet 2, based on certain conditions. Populate Sheet 1 Holiday column with data from Sheet 2 Holiday column, only if: Sheet 1 Date matches Sheet 2 Date, AND Sheet 2…
-
Create a Form with Auto Filled
I have a sheet (Sheet 1) that is my Master Project. Each project has to create subtask request for another department (within Sheet2) but a lot of information prefilled in Sheet 1 needs to be fulfilled into Sheet 2 when the request is made to that other department. Is there a way to create a form within Sheet 2, use the…
-
Count Cells that begin with a specific text
I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero. =COUNTIF({Reference Sheet}, "ABCD") Is there a formula to return the number of cells that have the first four letters as "ABCD"?
-
Date formula in content calendar template
I'm trying to copy the content calendar template into the rest of the months for this year. It has January filled out but the rest are blank. I'd like to have the week column updated to the correct dates for each week in the month. I can't seem to figure out the formula to correct the issue (you can see below the date is…
-
Combining Formulas to make one big Formula
I currently have all the individuals formulas i'm looking for however I'm having trouble combining them into one formula that I can embed in a cell. I know I can create a workflow automation to get the result I want however I enjoy the rapidness of using an embedded formula. Does anyone know if it's possible to combine the…
-
Formula to check off a box if date is in the past and not blank
This is one of the formulas I've tried: Thanks for your help!
-
COUNTIF one field or another has a value across a row
I need to count how many tests have at least one result without counting all of the results for each row. For example, in the chart above I have 5 tests. I need to know how many of those have at least one result, but not count the total number of results. In this case I have 4 tests that have at least one result. How can I…