-
Card View - Lanes by Parent Task?
My sheet is setup with the following levels with how tasks are nested - see screenshot. In the card view, I want the lanes to be the Project Setup level tasks. I have a column formula where I am extracting the parent name and then viewing the lanes with that, but that is pulling everything at the Task 3 level too. How can…
-
How to Nest IF statements in the correct order
I am tasked with collecting labor rates per employee, but the labor rates change based on the dates posted. For instance, I have old labor rates applied to dates older than December 1st 2023. We recently had some promotions and now I also have to pull labor rates after March 28th 2024. The labor rates after March 28th are…
-
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…
-
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…
-
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…
-
Formula to automate the symbols on a sheet.
The Task Progress column is linked to the % Complete column. when someone inputs a value of 100% in the % complete column, the task progress changes to a Green dot, and the same goes for when the % complete is 0% - Red dot, 1-99% - Yellow dot. I would like to add a gray dot in the mixture so I need a new formula to reflect…
-
Why does Smartsheet add a single quote before an integer that begins with 0?
A single quote keeps getting added when a 0 precedes an integer regardless of the entry method for the cell’s value (e.g., when the values are imported into Smartsheet from an Excel file, when the values are copied and pasted into Smartsheet or when the values are manually entered). Example: 099999999 changes to ‘99999999…