-
Difficulty with sumifs formula
I was hoping someone could help me. Having difficulty getting my sumifs formula to work. I am trying to sum a total if a project is closed and for projects closed within the year 2020. Currently this is the formula I am trying to use (tried different variations to no success): =SUMIFS({Cyndy Brewczak Project List Range 1},…
-
VLOOKUP and Large returning Correct value but wrong Description
I have the VLOOKUP set up but it’s returning the wrong result. For example: According to the Large function, 6,990 is the amount that we’ve spent the 5th most on so far this year, when I scroll through and find that total, it’s the Sidelaster Conversion that show's we've spent 6,990, however it comes back as the BDF Boxtoe…
-
Vlookup with Large formula as the search value
SOLVED* REALIZED THAT I HAD AN EXTRA ) IN MY FORMULA!!! Hello everyone, I have a list of items that pull from other sheets what we're spending on each one. From there, I have used the large function in a cell to pull the largest totals and rank them from 1 to 5 for a "top 5 spender list" I would now like to pair up what…
-
Collect formula to return a value @row in cross sheet
I'm trying to get the following formula to work: =COLLECT({4.01 Backlinking Range 6}, {4.01 Backlinking Range 1}, [Root Domain]@row, {4.01 Backlinking Range 3}, [Date Last Backlink Live]@row) Range 6 is a range where when the other criteria are met, I want the value @row to return. Range 1 is a a bunch of "root domains"…
-
Duplicate Checker based on multiple conditions
Hello, I have a duplicate checker formula that was working perfectly until recently.. The recent change was that we started getting phone numbers in different formats (see screenshot). Here's the formula that has been working perfectly: =IFERROR(IF(LEN([Person - Phone]@row) = 0, "", IF(COUNTIFS([Person - Phone]:[Person -…
-
Sum if criteria matches Row and column values
I have this table in one sheet. This is my other summary sheet In my other sheet I wanted to auto calculate if name and week number matches like Sumif name is x and week is 1 so answer i should be getting 7 (i.e. 4+3). Please help.
-
Complex Formula to return latest date a specific value was used and return a value from a dif column
Alright, I've got a pretty complex formula (at least for me..) that I've been banging my head against and could definitely use a little help from the awesome community! Here's what I am trying to do (see screenshots for reference). I'm attempting to create a formula in the "Latest Backlink Live" Column. I would like the…
-
Vlookup Function from Right to Left
Hello Everyone, Can someone help to understand how I can do a Vlookup from Right to Left. I am trying to add a unique ID to the right most column of two sheets and do a vlookup from Right to Left. While exploring this topic, I found solution to do it using CHOOSE in EXCEL however bit tricky in SmartSheet. Hope someone who…
-
Auto create incident number based on last name + number
I am trying to create a formula to take the first 4 letters from the Salesman Name column and add "-001", etc. to the end of the first 4 letters to create an Incident Number. My coworker created this formula and it's almost working, but isn't always taking the first 4 letters from the last name (see line 3 (incorrect) vs…
-
Calculating a date in the future
My use case: I receive reports that need to have an SLA tracked. From the date I receive the report, I need to calculate the due date. If a report has a severity of Critical I need to calculate the report date +60 days, if High, the report date +90 days. I have a severity column with CRITICAL, HIGH, MEDIUM & LOW, I want to…