-
Change cell color based on date from another sheet
Hello! I'm working on a project overview sheet for many overlapping timelines. I'd like to make it so that if any of the projects have the date that the column is named that cell highlights or changes color. So, for example, if project 1 timeline had a date associated with 9/12/21 then the cell joining those two would…
-
Row height issue
I know that row height can not be manually adjusted like in excel, that's usually no problem. In my case, one sheet has had some select rows height change, as if someone wrapped/unwrapped text or changed the text positioning but the formatting didn't follow. I have un-hid and checked every cell for a spot that may have…
-
How to List Parents By Common Child
I am working on a project book of work and currently have a list of resources listed by project: Project 1: Rich John Angela Carly Ted Project 2: Tim Jeff Rich Ted Project 3: Sam Tim Ted I am looking to create another sheet that will automatically pull from this first sheet and show the resource and the projects that they…
-
Use DISTINCT with COUNTIFS
Hey Guys! I am so excited to see that Smartsheet has finally introduced a formula that will compute DISTINCT(Unique) values!! So, I am trying ot develop a formula to calculate DISTINCT count using one column but with a few condition(s) i.e. IFS i.e. [Range1,Criteria1, Range2,Criteria2] Refer below a sample of that…
-
Baselines - Variation Field in Business Days?
Really happy to see this baseline feature in Smartsheet and have been using it effectively. There is one item that doesn't quite seem to make sense with other smartsheet behavior for me. The Variance shown is in absolute days between two dates - I understand a logic for that, however given the duration column is processed…
-
Index Match Showing Incorrect Amounts - Formula when there is no information to pull
Hello! I am stuck on the INDEX MATCH pulling incorrect amounts when I reference another sheet. It will work for some cells, but not others. I am thinking since the parent sheet doesn't have all the line item costs for each store such as "Shelving" or "IT/LP", that could be the issue, but not all stores will have those…
-
Manpower Summation from Schedule
Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", "piping subcontractor" etc. My schedule is about 1500 lines long with lots of concurrent activities. My…
-
How to get realistic timeline of the project considering the resource allocated
Hi all, First time using smartsheet and haven't been able to figure it out. I searched on this forum and seems like back in the days people had similar issues. Not sure if it's been resolved or not. Here is the issue: I have contractors that are helping with the project. I need to get a realistic timeline to know when…
-
How to count children rows with multiple criteria
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status". Each parent row is a different year and beneath each year are cases IDs (these are in the caseregnum column). The cases are categorized into "general" and "special" (this is the type of…
-
Master Roll-Up for multiple project sheets
I am reviewing the Construction and Facilities Management template set provided by Smartsheet. I only have a Team account for now. The template comes with 2 sheets for Projects. In the Master Roll-Up sheet, you can see the formulas used to pull the info from the 2 Project sheets. Question: Do I have to manually update the…
