-
Partial Match for a Vlookup
Hi All, I am looking for some help with a formula. I want to search for a particular value in a cell that may include multiple values i.e I want to locate A123 but the cell from the reference sheet contains A123; B456. My thought was to use a partial vlookup but from what I have read it does not look like wildcards can be…
-
Creating SUMs based of a multi-select column for each selection.
I have a report that has a multi-select column with a variety of selections. I am trying to create cells at the bottom of that report that show the total #/SUM of each selection that are within that multi-select column. (Ex. I have a sheet that has column with you can select Active, Pending, Completed from a drop down. I…
-
SUMIFS Formula to calculate the sum between dates
Hey Smartsheet Community, I have a rather simple formula that is giving me trouble, I am just trying to get the sum of a revenue column between two dates. So far this is what I have and it is coming back unparseable: =SUMIFS({start date}, >[Start Date]@row AND({end date} < [End Date]@row), {revenue}) Any help here would be…
-
Formula that will display the lowest value from two data sets (with the highest value).
Hello Smartsheet community, I need some help fixing a formula. The goal = Display the lowest value between (the highest value between 1A and 1B) and (the highest value between 2A and 2B). The formula I created is: =MIN(COLLECT(MAX(COLLECT([DATE 1A]@row, [DATE 1A]@row, @cell <> ""), COLLECT([DATE 1B]@row, [DATE 1B]@row,…
-
Using COUNTIFS
Hi All, Newbie posting. Been using smartsheet for my projects and keen to delve more into the reporting side for Board information. I have a Smartsheet that I use to record installs of certain types of products, we have three different types. I have used a formula to count the number of each type of product with an example…
-
Active turn around times by status of a row
I was wondering if theres a way/formula to track the amount of time a line stays in a certain status. For example - If we are using a line to track the life cycle of a contract we would have a created date field and a contract status field. The status field would consist of fields like "Contract Review" "Legal Review" "On…
-
Get the 1st value of Children
Hi, I would like to get the 1st value of children. Please see example below.
-
Conditional Copy from Sheet A to Sheet B
Hi everyone - have looked through the forums for items like "conditional cell linking" (which would be awesome), but cannot find what i am looking for; not sure if this is possible, super complex, or something very basic/simple that i am glossing over. Essentially, i am trying to move data entered in "tableA" to "tableB"…
-
How to show a "Completion Status" column based off of certain cells containing value?
Hello Smartsheet community, I have a database containing the amount of training specific employees have received. I would like to create a formula that is able to recognize what level someone is at and then the training needed for that level. If they have received the training it would show as "complete." If they have not…
-
Referencing Multiple Columns in another sheet to Match a Location and Date Range to a Project
So I have been looking through the community for a while and have seen a couple solutions mildly similar to what I am looking to do, but can't quite get it right. Feel free to link me to another solution if you feel it would solve this problem: I have a reference sheet which I do not own that contains a listing of Tasks…