-
IFs, Index/Match and Check Boxes
I have 2 sheets: Sheet 1 - uses a form for initial information. Additional columns exist to provide resolution information, including assigned to (contact list) and closed (checkbox) Sheet 2 - used to lookup values to populate the assigned to column on Sheet 1 based on the Region provided via the form. I am using…
-
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:…
-
Month Function Sorting in Report
Hello! I have a sheet that captures items and their start/end dates in a date format. I am trying to create a report that will group the items by the Month that the item is taking place in chronological order (Ex: All items with the target end date in January would be grouped under "January", followed by all items with the…
-
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…
