-
% Complete Without Dates
Hey There, I work for a construction company, and one of our subdivisions has multiple townhome blocks. We are currently building 3 blocks, but don't know when we will start the other ones (all dependent on sales) I'm wondering if there is a way to get the % Complete for the whole project, not just the blocks currently in…
-
Need help assimilating data based on row conditions
Hi there, I need some help regarding formulas in Smartsheet. I have a raw data entry sheet, where I am entering the number of Work orders my production team is working for the day. I am trying to find a way to pull in corresponding columns of data sets based on the date column. In the first photo, you can see the raw data…
-
Summary Sheet Pulling Blank Hard Returns in Join statement
Hi! I'm using a Join formula to pull entries in my "Key Accomplishments" column into a Sheet Summary field when my "Pull Into Reporting?" column has a checkmark (using a formula to check if the entry is for the current week). I'd like to have a hard return between each entry being pulled into the Sheet Summary field. My…
-
Fiscal Year Formula?
I'm looking for a simple formula to generate my fiscal year using the date entered in the "Date of Accident/Incident" column. Fiscal Year Start: Feb 1st Fiscal Year End: Jan 31 Outcome desired: If today's date is 1/20/23 - Display 2022 in FY column If today's date is 2/01/23 - Display 2023 in FY column Hope that makes…
-
Update cell in main row based on values in a group of rows?
Hi there -- I have a sheet that does not use hierarchy, but does have a main row with related rows under it. The main row has a milestone "Primary" and the subsequent rows have Milestone 1, Milestone 2, etc. Within the milestones, there are tasks, such as Task 1, Task 2, etc. I would like the status on the primary…
-
Moving data from one sheet to another - nothing works! VLOOKUP, INDEX MATCH, INDEX COLLECT
Hi Community! Hoping one of you might know what I'm doing wrong here. I'm trying to bring data from my source sheet (a list of requests) into a target sheet (list of placements). I've created a reference ID that exists in both sheets (KP Placement ID) that is an auto-generated number in the source sheet. It's manually…
-
Formula to find and retrieve a specific value from a list with multiple values
Hi Community, I am not sure what formula or combination of formulas to use for the below example: I have a list of Spring products, each product is sorted into a type, and a similar list for Fall products. For each product I have a column to check if that specific product has an image. In a different sheet (here I use…
-
Need help with COUNTIF
When I use this formula, it works fine, =COUNTIFS([Date Request Submitted -System]:[Date Request Submitted -System], <=TODAY(), [Date Request Submitted -System]:[Date Request Submitted -System], >TODAY(-7)) + COUNTIFS(Status:Status, OR(@cell = "Submitted", @cell = "Acknowledged", @cell = "Revisit Underway")) As soon as I…
-
Average IF Within 30 days
Hello, I am trying to figure out a formula to average a particular column of information, but only within the last 30 days. I have a "Todays Date" Formula/column already created, but not sure how to write the formula to be able to read my whole column of data but only pull from the past 30 days. I appreciate any help in…
-
How to edit filter to include YEAR function
So I had this formula created and its searching by a couple of different metrics to gather the average of a column but only via the supervisor name for another column. Silly me forget we only need to spit back data from 2024 as the sheet collects multiple years worth of data and my brain is really struggling to add this…