-
Updates Occur After Date Specified is Reached
I need for updates to Profile sheet to pull data from Exception sheet only when the date is reached based on the employee #. Scenario: An employee wants to increase their 401K contribution by $100 every quarter. Profile has Benefit Effective Date: 4/1/22, 401K Contribution: $100. Exception sheet has 3 exceptions submitted:…
-
JOIN COLLECT FORMULA
IN PICTURE (A)- i have successful JOIN COLLECT formula IN PICTURE (B)- I tried to replicate the formula, but add additional columns I needed to be joined as well. IN PICTURE (B-1) Incorrrect Argument
-
Extracting multiple lists by category
Hi. I have a master sheet where each row is allocated one of four categories. I would like to extract this data into another sheet, into different columns dependent on the category (i.e. four columns for name, one per category, four columns for date, one per category). All the functions I have tried (vlookup, match/index…
-
COUNTIFS range formula while referencing another sheet
Hello, I am unable to figure out how to count the total number of cells that are in a certain status AND range between 31-60 days while referencing another sheet. I have used the formula below to get a total when a cell is in the "Assiged" state AND is less than 30 days and it worked. I've also provided a screenshot of the…
-
How to import data from other sheets?
Hey all. So I am looking to set up 2 sheets for inventory tracking. The first sheet will be a 'database' of SKUs along with item manufacturer names, model numbers, SKUs etc. I want to use that database sheet to feed my inventory tracking sheet. Ideally what I'd like to set up is: Item Sheet: select SKU-001 Sheet references…
-
parent child vlookup
Is there a way to use a sheet that has parent-child as a Vlookup for another page?
-
Auto-populate vacation time in production timeline
I am trying to see if there is a way to automatically blackout vacation time specific to a person, similar to the way holidays are able to be blacked out.
-
Cross Sheet Formula with One Criteria
Hello, I am creating Smartsheets for quality assurance testing. Sheet #1 will be the test scenarios and steps taken. The row will include a drop down menu to indicate if the step passed, failed, etc. I need a formula that if "Fail" is selected from the drop down menu, the step's ID # will automatically pull into Sheet #2…
-
Maps & Hyperlinks
I know that the smartsheet charts app is still in production, but is it possible to have sheet containing North American states and hyperlinks, then using the 'map' chart, click on a particular state and then it will take you to that hyperlink?
-
CONTAINS with Trigger Search
Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device type that contains "Coin". This address will then be checked against the address column until…
