-
Copy live data from certain columns from one sheet to another
I have a very large sheet with 58 columns and over 3,000 rows but continually adding until it gets full them with push to a new sheet. Anyway I want a new sheet that references the data in only a few on the columns in the primary sheet. I tried using INDEX function but I'm unable to get it to work. Is this the best option.…
-
Adding a number based on a percentage
Hello, I gave a column that has the cost of goods, I want to add a column with a formula that will give me the total with a 25 percent markup. Should be easy but can't seem to find how to do it right. Thanks in advance
-
I need to string together many conditions
I have 8 conditions I need to string together, if all are met the formula should return "yes" if anything any condition is false, the formula should return "". I have tried nesting If/ and statements a number of ways, but since they all need to work together I am coming up #unparsable with each iteration. =IF(AND([Contract…
-
Display RYG based on calc of two sheet summary fields and IF/OR statements
Hi, I'd like to display Red, Yellow, Green in a Sheet Summary field based on the calculation of two other fields, Past Due and Total Tasks. I'd like it to show Red if Past Due divided by Total Tasks is greater than 60%, Yellow if between 40% and 60%, and Green if less than 40% I'm new to Smartsheet so could be way off:…
-
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:…
-
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…