-
Flagging duplicate registration plates
Hi, this is my first post on the forum. I use smartsheets for work but I have created this account to use the forums. I am attempting to create a formula that will allow me to use conditional formatting when two entries use the same registration plate number. The sheet is set out like this (im unsure if the link at the…
-
Dashboard showing status of symbols
Hello community, I apologize if this comes across as trivial, but I am wondering what the optimal solution is to show charts (pie, mostly) showing what percentage of cells in a sheet have the symbol Red Dot / Green Dot / etc. Can I access those symbols directly? Or can I do some sort of IF statement which assigns a value…
-
Complex Formulas requiring a lot of editing
Hello, I need to count the number of projects in a certain status, work type by person. I created this formula and it is working but it requires a lot of editing. =COUNTIFS({Assigned To - BD}, "Charles Kimball", {Implementation Status - BD}, "Pending Kick Off", {Work Type - BD}, "Advanced Billing"). This formula is looking…
-
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.…
