-
COUNT but not if duplicated in another row
Hi Looking for some help with a formula... really not sure where to start. I have a sheet where each line relates to scaffold that has been built which is populated by a webform. Each line has a tag number and if I count all the tags in the column Tag No, I can see how many scaffolds are in place. The webform also collects…
-
Adding two different criteria together which are found in the column
I am trying to add up how many times "INVENTORY" is used in my column and how many times "READY2SHIP" is used in the very same column. I tried sumifs, countifs, but none of these seems to work. Could you please assist me? The same column has several status. Only one status applies per row. I want to see how many times I…
-
Multiple sumifs
=SUMIF([Platform Site]@row, CONTAINS("eBay", @cell), Net@row - [PayPal Fee]@row) =SUMIF([Platform Site]@row, CONTAINS("fsx", @cell), Net@row - [Platform Fee]@row) These work independently but I need them to work together for a column formula. When I try to put them together, I keep Error messages. Help. I have to have this…
-
Calculate Harvey Ball if another field is "yes"
I have a Text/Number field, which is "yes" and "no". I only want the Harvey Ball to calculate on the %complete field, if the answer to my Text/Number field is yes. If no, I should not populate anything in the Harvey Ball field. Can I do this? Otherwise I could try an grey the field out with formatting. Thoughts? Thanks so…
-
Checkbox formula based on 2 columns matching
Hello, I'm sure i'm creating extra steps for myself on this but here is my issue at this time. My goal is to set up notifications on one smartsheet when there is a manager change on the master smartsheet. I broke it down into steps. First, I created a formula on the smartsheet I want the notification to populate. I have my…
-
SumIF Cross Sheet
I am simply trying to summarize AR data for a dashboard on a summary sheet. I need to know the balance due for each company totaled up. Below is one of many attempts I have tried. There are only six options so I canmanually update the formaula for each company but that didnt work either. What am I messing up? Thank You
-
Cross Sheet Reference Formula
I am trying to write a cross reference sheet formula to count MTD dates in a column using this formula I found here but it is not working. Thoughts? =COUNTIFS({Andee Metrics Terms}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()), IFERROR(MONTH(@cell), 0 = MONTH(TODAY()))))
-
Most recent date
Hi all, I hope you are well! I'm looking to have a parent row that includes the number of people a project has been deployed to, with children rows that will be added and updated when relevant (weekly/monthly). I'm hoping to pull through the most RECENT date information into the parent row and an to have the option to…
-
Help With Collect Function
I have a sheet that has three columns - DueDate, Status and "Status by Color" respectively. Based on the entries in the status column the "Status by Color" cell is assigned the color Red, Green or Blue. My need is to identify the 5 oldest 'overdue' dates within the DueDate column. I achieved this using the following…
-
How do we format chart type when adding a widget with a combination of bar and line graph?
I'd like to know how do we customized our chart if we want to combine bar and line graphs in one report. Does anyone able to do it given we only have a limited chart type? Appreciate your responses, thank you.
