-
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!
-
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…
-
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…
-
RoundUp Decimal Issues...
Trying to get a formula where any decimal number above 1 will round the next highest whole number (examples: .33 will round to 1, 1.33 will round to 2, 3.23 will round to 4, etc.). I also need if the formula = a negative it displays a 0 as opposed to -4. current formula using and somewhat working =MAX(IF([Paper Towels]2 /…
-
Get values in card header display or get total items of a type without countif for each?
When viewing by a category in card view (think color), it places the number of items in that column in parenthesis next to the column title. All of the "blue" items are in the column and the column header is "Blue (22)", the next would be "Red (12)" and so on. Is it possible to get that number for use in a dashboard (and 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"…
-
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.…
-
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…
-
Using VLOOKUP to return a most recent date but with conditions
Hi there, I'm looking to pull off the following: * Smartsheet A is a list of stakeholders we regularly engage with. Every row is an individual stakeholder * Samrtsheet B is a tracker where we list the engagements themselves. Every row is an occasion where we have interacted with a stakeholder. We categorise these…
-
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…
