-
Combine LEFT and VLOOKUP Formulas in one cell
I need to combine two formulas in one cell. One formula removes a specific text from the body of the email and another formula maps it from another sheet via a VLOOKUP. How would I combine these two formulas? Thank you!! =LEFT(Text@row, FIND(">", Text@row, 1) - 1) =VLOOKUP([Interface Log]@row, {Interface Raw Data - Daily…
-
INDEX MATCH Formula with row Hierarchy
Hello, I need to reference information from the Digital column and Match it into the Digital Row. The row in white is the Parent column and the rows in grey are the Children. Here is the formula I'm using: =(INDEX(PARENT(Digital@row), MATCH("Digital", CHILDREN(WO@row), 0))) In the Parent row the cell is blank, but in the…
-
Current & Previous Month formula
I'm trying to work out a formula that says if the date in the [Date Column] is the current month insert the word current, but if it's in the previous month insert previous, if it isn't either of those leave blank. What's the best way to do this?
-
Can't work out why I am getting an UNPARSEABLE error message please help
All I need is the correct return according to the Probability and Impact criteria in screenshot 1 into my Risk log in screenshot 2 Screenshot 1 =INDEX(COLLECT({Risk Management Matrix Range 1}, {Risk Management Matrix Range 2}, Probability@row), {Risk Management Matrix Range 3},Impact@row),1)
-
Elapsed Time from Today
Hi there, I'm trying to write a formula wherein I can track elapsed time since an injury occurred at work. My team would submit daily on a form created and based on the logic I'd like it to parse the data and determine if a 'yes' value is entered then the days elapsed would reset. If a 'no' value is entered then the days…
-
Calculating Duration (showing overages by number of days)
Hello, I am trying to run a duration formula based on the start and end dates on a project and the estimated dates. The estimate dates are how long we think the project will take, the start and end are the actual dates for the projects life. I also need to factor in a break down of each month, so in other words duration…
-
Return value from MATCH function
Hi all, I've got an INDEX/MATCH error that is stumping me. I have a lat/long identifier that I want to bring into a variety of other sheets. I am trying to match a street address to this identifier for ingestion into the target sheet. As you can see in the reference sheet screen shot, variations of input will have the same…
-
Count & If formula
I am trying to create a formula where I will get a count of total Solution Design by Zone. I can get the count for each separately but I can't get it to combine. Column 1 - Zone & Column 2 - "Solution Design" =COUNTIFS(Zone:Zone, ="West", "Solution Design":"Solution Design") Thank you in advance.
-
An "Average" formula which does not consider a cell with "zero" value
Hi Smartsheet Community, I'm looking for an "average" formula for a set of cells. However, some of the cells have a "zero" value and the formula musn't average across those cells, only ones which have a positive value. Please see an example below: Average of only cells which have a number - if the number is "0", then do…
-
Duplicate data formula which references two values
Hello Community, I am trying to find duplicate invoice numbers for the same client within two of my sheets. I need to show if there have been any duplicate invoices for clients using two criteria but am unsure how to create the formula. I want this information to show in a checkbox form. =IF(COUNTIF([Invoice #]:[Invoice…
