- If, Index & Collect Formula issues
I have an issue with my current If, Index, and Collect formula. I have two sheets. One for data collection, and another for the Reviewer's Agency, Schedule, and Email address. I want to automate this process where if I have a TFD C shift, the Reviewers email address will be added into the data collection sheet. Here's my…
- COUNTIF as of Today?
Hi, I have a sheet I'm using to calculate the number of open tasks on my project. =COUNTIFS({Corporate MOC Location}, CONTAINS("BER", @cell)) The reference sheet is constantly being updated as and when actions are completed. I want to cell link this count to my KPI sheet to track the performance of the team over the course…
- VLOOKUP not pulling in correct data when duplicate names
Hello I have a line of business with three choices: deploy, consult, and managed services, each associated with all theaters. When someone submits a request through the intake form, they select one of these options, and the form populates the data into the Sub_Org column based on the chosen line of business, and theater.…
- Can you pull between two times when using the countifs function?
When using the Countifs function, can you reference the created column (which includes both the date and the time) and pull based on submissions between certain times. EX: =countifs({Form Date}, TODAY() - 1, {Form Date}, "04:30pm:11:59pm")
- INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
- How do I create a formula to pull the year from a date from every row in a column?
Hello! I am very new to formulas, and I'm having a hard time figuring them out. I want to create an automatic function that will pull the year (and separately, the month) into a new cell, so that I can break down my sheet into year, and then month, with collapsible rows. Basically, I have a row titled "Date of Employee…
- If OR and SUM formula
Hi, I created this formula but I'm not sure why I'm getting the error message "INVALID DATA TYPE" =IF(OR(Name@row = "AB", "CD"), [Number1]@row, SUM([Number2]@row:[Number5]@row))
- Data transferring
I'm trying to transfer information from sheet one to sheet two, then update the information on sheet two, and then that information to be transferred to sheet one.
- Seeking Assistance - Average Days Open, by Status, Month/Year
嗨,我想计算average # of days for data set, where the Status is "X", and the M/Y = "Y". I'm good with "AverageIf" = label@row, but not sure how I can incorporate the date piece. Thanks in advance! Sharing some snapshots of the data, all columns (Total Days Open, Completion Status, Leave Blank...)…
- Perfect Match
Hi all, I am trying to figure out a way on how to match mentors with mentee. I have a survey that i send out to gather the info with a series of questions regarding skills that you can teach(Mentor) and skills that you want to learn (Mentee). How do i match a mentor with a mentee that have mutual interests (teaching and…
