-
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 -…
-
Update a cell from the list with condition
Hello Experts, How to auto update a cell from the list when conditions are met? e.g. (screenshot) If the status is 'In Progress' - Look for the first available gear in the list and update a cell of a row (In Progress) with the first available gear ID. Please Help!!
-
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.
-
Wildcard
Hello All, I feel like a lot of the issues with Smartsheet functions would be fixed by adding a wildcard function. Are there any talks to incorporate a wildcard function to Smartsheets? Thanks
-
How do I show project 'In Progress' when % Complete rounds down to zero?
I have the following formula: =IF([% Complete]@row = 0, "Not Started", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 1, "Complete"))) If I start a task that and percentage isn't 0.5% or greater, it shows the project as not started. It appears top line in project has default…
-
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…
-
Formula to Give Last Day of Current Quarter
I want a simple formula that will take today's date and calculate the last day of the current Quarter. Meaning, if today is 12/15/20 then the formula will give "12/31/20" and if today's date is 1/15/21 then it will give "3/31/21". I used a super complicated if statement but I don't want to have to update this each year.
-
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…
