-
IF, RYG and range
Hi All, I'm growing absolutely desperate. I have gone through what feels like a milion various posts on here, but nothing quite seems to answer what I need. I am trying to set up RYG conditions based on monthly estimated FTEs so that if the FTE is higher than 1 in any of the columns, the ball goes red. And I am wondering…
-
My Formula looks incorrect
Hello, I am attempting to get a Margin (%) for my outcome, however I have received "unparseable", "incorrect argument" "invalid" when attempting a few variations. Am I overlooking something? I need to get my The formula I am using in smartsheet: =IF(ISBLANK([Customer Cost/Booking $$]@row - [Partner Cost $$]@row), "",…
-
Formula to match Payment Terms to a number (Nested If Formula)
Hello, I am trying to match a number based on the value of Payment Terms. For example if Payment Terms if NET 30, NET 45, or NET 60 I want to make a formula in a separate column that match the number portion. For example Net 45 should become 45 in a separate column. My formula only seems to work if the Payment Terms is NET…
-
COUNTIFS Referencing Other Sheets
Needing help with the COUNTIFS and referencing other sheets. It keeps coming back #unparseable I am trying to find the number of projects in a certain phase based on who the project is assigned to. Active Leads Range 11: Assigned to Active Leads range 10: Phase . =COUNTIFS({Active Leads Range 11}:{Active Leads Range 11},…
-
If Cells not blank equal max date
I have a sheet with 7 columns that have dates (was checkboxes but could not get it to work) I want an 8th column to populate the max date from the 7 columns ONLY if all columns have a date entered. Basically I am tracking when people submit multiple documents, once all are submitted (i.e all dates entered) I issue them a…
-
COUNTIFS OR Function Error
Hi, I'm attempting to create a formula that will count the number of requests that are pending review. The column uses a drop down menu with three options, Submitted, Approved, or Declined. I'm trying to create a count in the Sheet Summary to count the number of requests that are still pending approval. The options that it…
-
Automate Harvey Balls Based on Date in a Column
Hello, This may have been asked previously however I cannot seem to find my specific request that only reference if a date is entered (not range related) so here goes. I have a Status column on a sheet and have it set to symbol: Harvey Balls. What I would like the sheet to do is to automatically insert the correct Harvey…
-
Need Formula Help - Dates and Check Boxes
I am trying to come up with a formula to count the number of items with any date within the month of January 2020 and have a box checked. I was able to figure out the formula to get the total count of items within the month of January 2020 using this: =COUNTIFS([Permit Start Date]:[Permit Start Date], IFERROR(MONTH(@cell),…
-
Color ball formula that measures date range across 5 columns to determine color based workdays
1) "Grey" = no date in [Last Activity Date]@row. 2) "Red" if date in MIN[Initial Presentation]@row through MAX[Qualified Win]@row is greater than or equal to 30 working days from [Last Activity Date]@row not including holidays. 3) "Yellow" if date in MIN[Initial Presentation]@row through MAX[Qualified Win]@row is between…
-
Formula that will add 1 to a Qty row
Newbie to Smartsheet...I am wanting to write a formula that would at a quantity of 1 if the prior column has a date in the cell. I am trying to calculate the # of installations. basically if a date is entered into an install date column, I need the formula to add a quantity to a install quantity column. thanks, sGF