-
Filter not working correctly
We have a sheet for project task and have set up shared filters so that each person can filter the task list to show only the task that they are listed as project manager. When the filter is selected, randomly there are task lines shown where other project managers are listed. I can't figure out why this is happening now.…
-
Automatically populating a cell
Hi everyone. Some help please. I've been through index match but I don't think it's what I want. What I want to do is... Someone submits a form with one of the fields being "sub job", selected from a dropdown. Once I go into the spreadsheet after the form is submitted, I want the adjacent "WD no" column to be automatically…
-
Formula to look for duplicates using multiple criteria
Hello, I currently have this formula which is looking for duplicates in APPID: =IF(COUNTIF(APPID:APPID, APPID@row) > 1, "FLAG") I would like to add another formula to this which will look first at the APPID to see if they are the same, and then look in the N column to see if the name is the same. If the name is the same,…
-
Using Match of the top parent row to do an index search in another sheet
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
-
Large/Index to return value once only
Please find example of the issue that I am experiencing in a Smartsheet column. As you can see in the screenshot, there are duplicate values in 9 & 11, then 12, 13 & 14. However, I wish to only populate the first value i.e. 9 & 12 and leave the others blank. In other words, I only want the latest/highest to populate with…
-
Is VLookup the solution?
I'm assisting a team with tracking data related to volunteer hours and instances of volunteering. We have a list of 50-100 volunteer agencies, and I'm trying to find the best way to track this number. We have employees self-report their volunteer hours quarterly (but they can do it as frequently as they would like).…
-
Multiple If statements
Hi, hoping someone will be able to help with an issue I am having with an IF formula. I am attempting to build an IF formula from check boxes, however it isn't as simple as multiple IF statements returning their own responses. What I am trying to achieve is a status update column, based off of the checkboxes. And therefore…
-
Compare Text between columns, one with text, one without, and return the text.
I have created a form that is for use with two separate groups, fields become available dependent on how respondents answer questions. I have a VLOOKUP formula set to pull in the address information from another sheet. Because this is used between two separate groups, there are two name fields. I am trying to compare both…
-
How to return "0" in a cell when another cell has been flagged
I created a timesheet and a form to go along with it. When someone uses the form and flags that someone has called off, I want the flag to return zeros in the ST Hrs, OT Hrs, and DT Hrs cells. Using AI to generate the formula below, it returns a Circular Reference error when the formula is placed in the ST Hrs cell.
-
Sum cells in varying column length with if-then?
Not sure if this is possible. Column can vary from 2 to X cells A couple of scenarios: A column two cells with 12 and 14. Total is 26. In the resultant cell 16 is inserted. (any sum of 17 or greater the number 16 is inserted) A column has a number of cells that total 14. Seeing that the number is less than 16 the actual…