-
I need to sum all cells where the "deactivated" box is checked and the date is after 2/23/2022
This is one of the formulas I've tried. =SUMIFS({Annual Billing Amount}, {Deactivated?}, 1, {Date to Deactivate}, ">=2/23/2022") Thanks for your help!
-
NESTED DISTINCT COUNTIF FORMULA?
I have another complex situation Now that I figured out how to "batch" items. The next thing I need to do is pull in a list of "Tote Numbers" that are associated with that batch. In this case I DO want the list to be within cell, but I also want it to be based on the batch number. here is a flow chart of the system - many…
-
Does anyone know if the CONTAIN formula is the correct formula to use?
This is my formula : =COUNTIFS({Requesting BU}, CONTAINS([Business Unit]@row, {Requesting BU}), {Final RR}, "Medium") / COUNT({Requesting BU}) I have a source sheet that contains a list of business units. One business unit has hundreds of branch offices so it will be too many to list. I'm trying to write a formula that…
-
Crossing multiple data bases with a Partial Text/Number match
Hello all! This is my first question. I am building a tracker called "My Project Tracker" that takes information from multiple "master sheets" built by different teams with different purposes. See screenshot for example. "My Project Tracker" has the "Project ID" as user input, then it populates the "Project Name" using the…
-
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…
