-
Need help with a complex formula
Attempting to write a formula in a sheet summary field. Is it possible to write a formula that looks for particular rows based on the text value in one column, and then get the AVG of the numbers in a different column on those selected rows? (ie. If the value in column Task is "Work Order Received", find the average of the…
-
How to find part of a string in another sheet
I have a sheet with a string, say xyz, this is not always the same length. In another sheet an have a column of numbers, which have values which are variable-length strings with values which in the case of the xyz is abcd123xyz I need to find the row that has the xyz is the column. Is there a way to do this?
-
Column isn't an option to filter by
fairly new to smartsheets, why aren't all columns available on the list when making a filter? I did not build this smartsheet but am the owner now so I am not sure if it's something on the backend I may not know yet. I need to create a filter with 4 conditions but only 3 of the 4 columns are options.
-
Complex formula using INDEX MATCH to update other columns
Hello Smartsheet Community, I am trying out how I can do an Index Match to look up data in column 1 and see if the data exists in column 2. If the data exists then update other columns ( like status , health and % Complete, Greatest milestone met) with Values Im truly in a time crunch , and will be super appreciative if…
-
Countifs Function with Multiple Criteria - Best Practices?
Hello! I'm having trouble understanding the best way to count multiple criteria in a countifs function. I can write simple countifs formulas, but the more criterion and ranges I add (seeking "and/or" results), the more errors I get. I struggle with combining ranges and criteria, I think because I don't understand how best…
-
Formula Assistance Needed
Wondering if you could help me with another formula in Smartsheet. What seems off about this one? =SUMIF([Payment Method]:[Payment Method], "", [Payment Amount]:[Payment Amount]),(Territory:Territory),(NOT("International")) I want to sum the "Payment Amount" column IF the "Payment Method" column is blank and IF the…
-
Sum months prior to current month
Hello, hoping someone can help me after trying to search for this issue on the boards. I have columns for every month of the year tracking project $ spent as well as projected to be spent in the future months. I'm trying to use a formula that will track the $ in the columns prior to the current month that can automatically…
-
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…
