-
How to use a value in AVG that is selected from criteria
Hello! Would like to ask a question regarding AVG and the ability to only pick up a value if a certain condition is meet. Here is what I'm using. =IF({Call Center_Help Desk Data Priority} = "Level 1 - Critical", AVG({Call Center_Help Desk Data Value TTFA})) Objective: To pull in a value to be averaged for all Level 1…
-
Pull Items from another sheet set for earliest date
I'm fairly new to SmartSheets and have been trying to figure out how I can pull items from my master list to show what is set for the next launch. Here is an example of my master table I want the new sheet to capture a different row for every enhancement in the example it would grab. A,C and E. Any help would be greatly…
-
Please Help!
I'm creating a CRM, I have 2 columns. One is the Sales stage with column properties (drop-down list) and the other is a probability% column with drop-down options. I want a formula that will add the percentage from the drop-down options based on the sales stage that's selected. Example if '1. Not Qualified' is chosen, I…
-
How to copy a sheet without updating system generated columns Created By and Last Modified By?
I would like to back up a sheet that contains two system generated columns, Created By and Last Modified By, which currently are populated for all of the rows. When I tried saving the current sheet as a new sheet, all of my rows in the new sheet get messed up because many columns contain formulas that extract the data…
-
How to get a lookup (Vlookup or Index Match) to return multiple values?
I'm essentially trying to have one cell populate with text values from multiple different cells based on a certain criteria. What I really wish I had is a JOINIF function, if that explains my problem better. Thanks in advance!
-
Date Calc Not Working
I feel like I am going crazy here.... I have a formula in the first column (formatted as a number) to take 04/27/22 and subtract 04/17/22 (both columns are formatted as date columns) but the result is 14? When I take the 04/17/22 and add that same cell of "14" I get 05/01/22. Has anyone else run into similar issues when…
-
INDEX COLLECT or VLOOKUP not working with numbers
I am in need of some help with trying to use either the INDEX/COLLECT or VLOOKUP functions. I have tried everything I can think of and nothing works. By employee number, I want to return their tenure. Both are contained in a reference sheet. Here is what I have tried. =IFERROR(INDEX(COLLECT({Tenure }, {Employee Number},…
-
COUNTIFS CONTAINS problems
Hello, I am trying to create a formula that will count the cells across spreadsheets using COUNTIFS and CONTAINS. My formula works, however I don't believe it is accurate since I am getting a count of 0 for every scenario I try and apply. I would like to count the "Requested Delivery Quarter", shown in screenshot two. By…
-
Multiple criteria
Hi community! i need your help, I need to get a number based if the formula find match with multiple criteria in different rows. How can I get the result in the left side (yellow field) from the information on the right hand??? Thanks in advance!!!
-
Formula to auto-transfer data into another sheet
The company I work for uses Smartsheets to build schedules. We have both weekly and daily schedules. However, I've noticed a lot of our time is spent daily going through and transferring information from the weekly to the daily grids. I didn't know if there was a way for me to auto-link certain grids to a grid on another…