-
Extract text from cell string using delimiters "/" into separated columns
Hi all, I've been fiddling with this for some time. I need to extract the text between the two / / In this case, it should return "PPA." I've explored a solution using the following post, but I can't seem to achieve success. Any suggestions? Extract text from Cell String using delimiters “|” into separated columns —…
-
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…
-
Formula to populate just the first row of data in another sheet
I'm trying to write a formula to populate data from one sheet to another but I only want the top row of data to populate and then update when the 1st row changes. I have a Submission Form sheet that gather data from a form, when a new form is submitted it will be at the top of the sheet. I want that top row of data to auto…
-
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!
