-
Countifs with nested Children
I am attempting to provide a count against 2 columns of children. I have an Open or Closed in a Status column and I have 7 references (Technical, Programming, etc.) in a Type column. I have multiple Parents (these are room locations) that I need unique roll-ups per room (parent). So, I am using the Children qualifier to…
-
BUG: #NO MATCH returned on X-Sheet Ref
I have two sheets, connected to each other via X-Sheet References. I tested this feature extensively when X-Sheet References came out http://ronin-global.com/2018/02/22/smartsheet-secure-your-sheets-with-x-sheet-references/ Today, I got this behavior On Main Sheet, I add a Row. I get a #NO MATCH on the return value. In a…
-
Forumla HELP! Check boxes then counting £ values in columns
Hello community This is my first post, struggling to achieve a formula command. can you help? I have several columns, one being a check box column named "Payment" When one or more of the rows is checked within this "Payment" column, I then need the system to calculate the £value across three other columns, names "30 days"…
-
task days in a year
been looking for ideas, but is there a simple way to determine the number of days any given project task has within a specific year? some tasks are just within one calendar year and some are across years, and I wanted to calculate the total number of days within each year by row/task. thanks!
-
Row number
Hi Thrill Seekers, I am seeking a way to access the row number of a row in a sheet. I would be very happy if this came in the form of a SmartSheet function (let's call it Row) so that I could create formulas like "=Row()" for the current row number or "=Row()+2" for the number of the row two rows below the current row.…
-
IF(AND) Statement in a Checkbox
Hello, I've been working on this for an hour or so now and I keep getting an unparseable or invalid error message. I want all applicable check boxes to automatically check off when a person is equal to or greater than a 3 rating. I need to do this for 48 people across 14 different work types. It worked when I clicked on…
-
Bug, Missed Release, or Senior Moment (column reference)
I am pretty sure that if I had a formula like this: =SUM(A:A) where A is a column, if I copied that to another column, it would update (ie, was a relative reference) It doesn't. If I copy this formula: =SUM(A1:A6) one column to the right, I get =SUM(B1:B6) as expected. There are three options: 1. This is a (newish) bug 2.…
-
Having Issues with COUNTIFS function
I have a sheet in which I reference another. What I am trying to do is reference two columns from one sheet to count the amount of entries that match the logical expressions. Here is my current formula. =COUNTIFS({Copy of Incident Report Range 1}, "Burn", {Copy of Incident Report Range 5}, 1) What I want the column to do…
-
See Current Sheet References and Delete them
I have a sheet i'm building and I have run into the maximum number of sheet references. This isn't a big deal as I've just made another sheet, and i'm going to use a report to conglomerate them, but I found out that I cannot go through my references and delete some of them, or even see a list of the references made. Is…
-
Formula Help with Symbols Column
Hey, can anyone help me with this? I have a column called Time to Comp which is a dropdown with the following - 5 10 15 30 45 1hr 2hr 4hr 8hr I have another column called TimeCompSym with the 1 - 5 stars. I would like this column to populate the stars based on the value in the Time to Comp column. 1 star = 5 2 stars = 10…