-
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…
-
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…