-
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…
-
MEDIAN formula picking up an extra row?
I have a sheet with a MEDIAN formula pointed to a column with a column formula to calculate the difference between two dates. Today the sheet happens to have only one row, but the result of the MEDIAN formula is that single value / 2. It looks like the median is picking up an extra, blank row. Any thoughts on how to…
-
Using cross sheet reference to pull data from one column in Sheet 1 into multiple rows in Sheet 2
I have two sheets. Sheet 1 is essentially a directory. It lists all of the individual contacts that are involved in a project. Some columns in the sheet are are "Name" (Contact List), "Title" (Text), "Department" (Text), and "Completed Assignments" (Text). Sheet 2 is where monthly assignments are recorded. The columns are…
-
Parent status based on children
This gets asked all the time and I've looked through posts but I can't get the formulas to work for my project. I have a project with hierarchy 1,2 and 3. I need the parents' status to update based on the children. My status options are: Not Started, In Progress, Complete and Blocked. If one child is in progress or…
-
Help with Formula Please
Hi, I am trying to find the formula so that the results show the total combined forecast amount but excludes any forecasted amount for an expected close date of 2025. Can anyone help please?
