-
Problem with vlookup calculations
I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of a calculated field that is based on data in another Smartsheet. Users enter data…
-
Blank Rows
We have a simple ticket tracking sheet. It consists of a couple dozen columns and one form. It don't use any hierarchy, so all rows are at same level. There are several columns that use formulas - some cross sheet vlookups, some date calculations, turnaround time, etc. Nothing too complicated, however, the formulas in…
-
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),…