-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…
-
Chaining "If" Functions
Hello, I'm attempting to capture if (4) columns contain DB01-DB12, and if a cell contains DB1-DB12 then it returns ONLY DB01-DB12 (see below for reference). I managed a formula for Db01 and DB02 but once I try DB03 I get an error (likely because it registers as IF False). Is there a better way to string multiple…
-
INDEX COLLECT across a range
Reposting now that I have a better understanding of my problem. I am a bit stumped and looking for a little help. I have a forecast sheet with a form where the user has to submit their monthly forecasts for the quarters across five subject areas. I have a column for each quarter and each subject area, 20 columns is my…
-
Need Help With COUNTIFS OR Formula.
=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], "In Progress") That formula is to count the number of cells that have "Now (1/1/24-5/31/24)" in the Timeline Prioritization column while also have "In Progress" in the System Status column. Based on the…
-
Return to a wrong value when using index and match formulas
When using the index and match formulas, the return value was correct before but when I refresh the search sheet then the final result start to be wrong and the same even the search value is not the same. Can anyone help to check and advice? Here is an example: formulas =INDEX({MMX-FOR PROTO TRACKER Range 1},…
-
Grab digits to the right of the "-"
I'm trying to separate the Area-Route column. For Area I'm using =LEFT([Area-Route]@row, FIND("-", [Area-Route]@row) - 1) and this seems to work fine. For the Route I'm using =RIGHT([Area-Route]@row, FIND("-", [Area-Route]@row) + 1) but this doesn't seem to work. You can see that their could be zero digits to the right of…
-
SUMIF between dates
Hi Community! I'm just trying total amount of "Booked" from Mon to Sat for the last couple weeks. Any help would be appreciated. Thank you...
-
Extract Date from Date and Time in Date Column
I have data pulled into a date column in this format: 6/1/2022 7:30:57 AM This is not a system-generated field. I need the date only in another date column. Thanks for any help! Lori Flanigan
-
How to link a column to a different sheet that auto populates when new rows are added?
I'm trying to do a workaround to adding multiple rows from the same form. I created a new sheet that has columns for requests 1-10. I want to pull certain columns from that sheet to move to a new sheet and then I can use a workflow to transfer that to my main sheet. I've created an ID column that autogenerates a number as…
-
Question about Sum Function
Hi all - I met an interesting bug when using sum formula in Smartsheet. I used sum function to calculate the total of above 6 cells. It should show 6, not 2. Each cell except the last total is using formula to calculate sum of each row. I use "+" because feb-28 and Feb-29 are added temporarily. Only Feb 28 & Feb 29 columns…
