-
Sum If Multi Drop Down Contains @Cell
I am struggling to get a formula to work correctly. I have a "Crew" Column which is a multi select contact column. I want the crew to be able to select multiple members and enter a single "Hours" for the day. For example Antonio and Tacho work the same job for 10 hours. Then to have each persons total hours for the project…
-
How to determine if a milestone is an extended milestone?
The formula value of [Duration]@row is a numeric value of 0 for both a Duration cell value of 0 and ~0. This means it is not possible to determine the number of work days that Smartsheet will then use for scheduling and % Complete calculations. Does anyone know if there is a way to determine which Duration cell value has…
-
What are the 'Order' options for RANKEQ and RANKAVG?
Hey, I could likely come up with this if I sat down and experimented with the formulas for a while, but I really feel like they should be listed somewhere and better documented and I'm really hoping someone else has already done the legwork. I don't even know if 'order' serves the same purpose in both formulas. RANKAVG…
-
I want to make a formula to work for all rows, details are below, Thanks!
This smartsheet has a parsing formula that we cannot convert as a formula column, I want this formula to be converted in a formula column, please guide, Thanks!
-
Combining IF and COUNTM?
Hello, all! I need to count items in a multiple option column, but only within a certain date range. If this were a single selection, I would use COUNTIFS, but this is different. Do you have advice on how to do this? I appreciate any guidance you can offer!
-
Nest IF formula
I have tried looking at the help but it doesn't provide details on creating nested IF formula. I am trying to say: If the column has name 1, then return statement A; if the column has name 2 then return statement B, if neither then return statement C. Any tips?
-
Referenceone sheet and if 0, reference another sheet
Hello, I've been using smartsheets for several years now but really only starting to use formulas until recently so forgive my lack of knowledge. I have three sheets in play here. The primary sheet is looking at the second sheet for an average based on all references of a SKU. The second sheet might not have data for a…
-
@cell Reference for Whole Column
I tried to create a formula with a structure like COUNTIF(column:column, YEAR(@cell)=2021) and was getting an error. I realized that if I changed to COUNTIF(column1:column23, YEAR(@cell)=2021), the formula would work. It seems that the @cell reference does not work when a whole column is selected. Does anyone have a…
-
Counting number of selections made in a multiselect column cell
I have a sheet that we are using to track partners that attend various meetings. The organizers of the groups select the partners that attend a meeting from a multi-select dropdown list. I need to be able to count how many partners are marked in each of these cells individually. For the screen shot below what I would need…
-
SUMIFS
Hi, I'm looking to sum the cells in a column if another corresponding column is either of two values. I'm getting #UNPARSEABLE though! 😕 =SUMIFS({Data Range Spend}, {Data Range Award Type}, OR(@cell = "Direct Award”, @cell = "Mini-Competition”)) Any thoughts welcome! Thanks, Derek