-
Summarizing a column in a report is only giving me a sum of half the data
I built a report from two separate sheets using a row report. I intend to add onto this weekly. When I try to total the sum of one column it's only giving me the value of half of the data. It's only giving me the total amount from the bottom half. Is there another way to group this information? In both sheets I've named…
-
How can I sum cells that include the abbreviation of states, but include commas in between?
As of right now I am summing selected cells, which then gives me everything that is in those cells. It is then merging them together, but I need it to include a comma if there is more than 1 cell that has information in it.
-
OR in COUNTIFS Formula
Helllo Community, I am struggling to figure out this COUNTIFS formula with OR included. I am trying to count the amount of cells on a separate sheet that have the same part number and their status is either "Repaired" or "Beyond Repair". I will paste my current formula below, and it is outputting invalid operation. Any…
-
Need empty column blank
I want to use a formula like this below but if there is no date in the other column to add +14 to, then leave row blank. =([CONFIRM OW PHOTO DUE]@row + 14) Need the "14" left blank
-
WEEKNUMBER and WEEKDAY
I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) to see who's "on duty" at that time. That contact's name is pulled into an "Assigned"…
-
extract part of a cell's text
Hello, New smartsheet user here. I have cells that contain dimensions of objects. A cylinder, for example, looks like this: Ø120*12. I need a way to extract just the text to the right of the *, in this case 12, to another cell. Another example: Ø18*1000 would return 1000. How do you do this? Thanks!
-
Ok, pulling out hair trying to get contains in children to work
Column L44 with groups. ultimately ends up inside an if, but just trying base formula to eliminate everything else. #UNPARSEABLE =CONTAINS("In", CHILDREN(L44)) =CONTAINS("In", CHILDREN(L44@row)) #INVALID COLUMN VALUE =CONTAINS("In", CHILDREN())
-
How to create a COUNTIFS formula with OR
I am trying to create a formula across columns with different values in a cell. I have the formula for one value, Preliminary Draft. This works fine. =COUNTIFS({Comments Log Range 1}, [Document Name]@row, {Comments Log Range 2}, "Preliminary Draft", {Comments Log Range 4}, "Open") However, the value in range 2 can also be…
-
If formula with several criteria
Hi, I was working on a formula last week, but I am still struggling with a second criteria on this. the way its set up, updating the field depending on dates being input into others. this works well as follows; =IFERROR(IF([Client review Required]@row = "Yes", IF([Actual Submit Date]@row = "", "Pending", (IF([Actual…
-
Combination of PARENT and LEFT function
Kia ora koutou, I'm wanting to combine the PARENT and LEFT functions to copy the first 6 characters of the Parent cell as a label for the Child cells. In my work, each parent cell starts with a code and then has a sentence (12+ words) as the title. I'd really like to be able to copy just the code e.g. A1.2.3 but not the…