-
Summary across sheets
I have two work plans with folks assigned to tasks and want to be able to see how many tasks on each sheet the person has assigned to them. For example (not in terms of formatting) Person A: Sheet X=# | Sheet Y =# Person B: Sheet X=# | Sheet Y =# I have a report grouped by person that has both sheets feeding into it but…
-
Formula to change status based on sheet value
I'm trying to change a status (from a dropdown box in sheet summary, based on a date field. When a check box checked the status would change. Sheet Summary Field is "Construction Status", drop down list is: Not Started Permitting In Progress Permitted Inventory Slab Starts In Progress Slab Starts Inventory Vertical…
-
How to make parents equal to the children list in a drop down menu
Hi everyone, I have been struggling for a while with this formula. I'm trying to have the parents populated automatically to be equal to the list of children in a drop down menu, without repetition if the same instance is repeated twice in the children. In the picture below I'm trying with =JOIN(DISTINCT(CHILDREN()), " ").…
-
sheet summary report not counting multiple different responses given in one cell
Hi all, I have a summary sheet report with fields drawing responses from surveys collected. The surveyed people were able to tick several possible answers in the surveys. These multiple responses appear in one cell, e.g. "how did you find the event?" and the answers are "fun, educational, accessible". I would like the…
-
Formula that will pull the most up to date information from
Hello I have a sheet that gets new entries every month and each month, the status of the project is calculated and may update. I have another sheet that holds the project information and it needs to show the most up to date status of the project. I was wondering if that is possible to do by a formula that will take the…
-
Sumif column name contains "Tax"
Hi All, I'm using smartsheets to track scores from daily quizzes taken by members over several teams. The end goal is that we want to compare the total scores from each team in a dashboard, so I'm trying to use the sheet summary to calculate the totals. Basically, each column on the sheet has one employee's name and the…
-
Formula Help with CountIf from another sheet
I'm trying to get the total count from a column in another sheet. The column is a drop down list and I'd like to get the count of a particular selection. I keep getting #unparseable no matter what I try. Here is my current formula. =COUNTIF({Source Sheet Column}:{Source Sheet Column},CONTAINS("Discovery",{Source Sheet…
-
IF + ISBLANK Formula
Hello, I am not being able to apply this specific case of the formulas IF and ISBLANK combined. Can I have some help? I want the formula to return "Pending" in the verification status column if all yellow cells are blank, and "Verified" if at least one of the yellow cells is filled out. Thank you so much in advance!
-
Intake data-> Project Sheet...Why so difficult????????????????????????
All I want to do is take what's in a row in the intake sheet and have it populate into a column in the project sheet. I feel like I'm making this too difficult, but after much review of previous helpful answers in this community, I still have issues I can't solve. Hoping you all can help. Issue 1 Index match gives me the…
-
Health Status on Report
Hi All, I've been building my files and reports. I've gotten my RGY formulas down, however, how in the world do I get it to give me a RGY health summary as it does for the other columns? I have a report that pulls in each rep as I have it below, just missing that one piece! Am I missing a step?
