-
IF/AND Formula with Dates
I get a #UNPARSEABLE error on his formula. [Permit Agency Approved] is a date only column [Permit Agency Approved (F)] is a date only column =IF(AND(ISBLANK([Permit Agency Approved]9)), [Permit Agency Approved (F)]9 < TODAY, "Review","None") What I would like to accomplish is, If the [Permit Agency Approved] column is…
-
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…
-
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…
-
Reference Row Number?
I'm building a task management sheet that prioritizes tasks by their order on the sheet. A formula calculates lead time of a task based on its current position in the list. Is there a way to dynamically reference the row number of a task? The easiest way would be a function that references the row number (since those…
-
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 /…