-
How to get a lookup (Vlookup or Index Match) to return multiple values?
I'm essentially trying to have one cell populate with text values from multiple different cells based on a certain criteria. What I really wish I had is a JOINIF function, if that explains my problem better. Thanks in advance!
-
hh:mm:ss Time Tracking in Smartsheets? (Probably not possible)
Howdy everyone! I've got a pernicious little problem that I'm wondering if anyone has any ideas about. My team and I currently track all of our break/fix help tickets in one dedicated "backlog" sheet. Each task that we need to complete is added to this sheet, gets prioritized, gets worked on, gets clarified (if needed),…
-
% complete in a row
Hi, i am looking for some help. I have a project which has 360 locations, resulting in 360 rows. i have 8 status columns in each row. is there a formula that will replicate a % by counting each status column that is complete and making that =12.5 . So for example all 8 status are complete this = 100, 6 status complete…
-
Matching a percentage dropdown entry
I've got a pretty simple requirement which I'm struggling with. I have a dropdown defined with % values for completion (ie 100%, 75%, 50% etc) and I want to create a formula which searches for completed tasks (ie any cell with 100%). I imagine this is pretty common. However, the cell type doesn't seem to be textual, nor…
-
substitute plan date with actual date
Hello, Trying to create a formula that can substitute the plan date with actual date. There are columns of Plan Start/End, Actual Start/End on the sheet, and the actual start & end are initially left blank, and once a task is kicked off, the one assigned is supposed to fill in the actual start, which substitutes the…
-
Formula help
Hello, I have been trying to work this one out. Attached is a picture of the column that i wish to tally. This column is a checkbox column and there are multiple parent lines (these are the colours lines) The top line is the grandparent line the white rows are the children. So what you see is each children row has some…
-
How to use All 4 Formulas together "IF AND NOT OR "
I have to create a formula that returns a value "1 or 0", so I use the IF statement. Now to satisfy multiple conditions, I am using the AND statement. Also, to I want to check if the statement is not true, Hence I use the NOT function. Based on this, the formula for my example is: =IF(AND([Actual Complete]6 < TODAY(),…
-
IF and VLOOKUP with multiple options
Trying to summarize from a worksheet to another (summary worksheet). The VLOOKUP should give an "X" if includes "August" and instead gives the same answer for every search since there are multiple of the original search; it's saying yes since it saw it the first time, but shouldn't if actually missing. Original worksheet…
-
Formula: If Status Changes to Something After Date
I'd like help in creating a formula that depends on another cell changing to a specific status, not if it is that status already. E.g. to have a checkbox get checked if the status balls of a neighboring cell turn red (after a certain time and date- the time and date of which I input the formula), but not if they were red…
-
Reference the contents of an entire column and return a RYG value
Hi, I am trying to return a RED value (traffic light) to a specific cell where any cell in the column "Risk Flag" has been checked. I can get it to return a Red value where a single specified cell in the Risk Flag column is flagged - as follows: =IF([Risk Flag]2 = "True", "Red") I need it to return a Red value where any…