-
INDEX MATCH is not pulling correct data even when formula is correct
Hello, for some reason I am having a recurring problem. Well, 2 recurring problems in the same vein. I am trying to pull in data from one sheet to another using index/match. I am positive that this formula is correct because I use it about 100 times throughout all of my sheets. In this particular sheet, this formula is not…
-
Is it possible to calulate average of a time metric?
Hello, I have a column for Avg Handle Time, where each row is formatted as: 0:00:00 How can calculuate the average of multiple rows? I know with Excel, you can just highlight the whole column, and it'll calculate the average automatically. How would this be done in Smartsheet? Thanks in advance, -Cyrus
-
IF formula correction please
Hi There, It is a Monday morning for me and a distinct lack of coffee means that the above formula is likely an absolute shemozzle. Essentially I am trying to return an argument that says If the Priority rating shows this (eg H5) then return this number (eg 15) in the helper column. This formula (once correct!) then also…
-
Formula: Counting Cell Values with symbols
Hello, I have a formula to count the entries for "Actual Hours" within a date range. For one of the values "<.5" the formula returns zero. I've tested a change to "lessthan.5" which counts as desired. I went back and ensured there were no erroneous spaces in the "<.5" value entry. Is this a limitation with formulas or have…
-
Unmark a checkbox if any instance of another sheet's checkbox is marked
Got a knotty question that I'm sure the savant's here can solve, as I am a novice at column formulas. The issue? We'd like to track average hours worked across multiple employees, however we don't want the employees who are currently training to dramatically offset the data. Thus, we'd like to check a box indicating that…
-
Help displaying a value present in another column if both conditions are met.
I've been trying to create a formula that will display the Remaining fifty percent when I meet two conditions. Set up to be billed has to be 50% and Live Date can't be blank. If both are true, then display the Amount due for Integration. I have tried to use If and If Contains to no avail.
-
Need to count number of answers by quarter. Difficulty: What were you thinking?
I am a bit stuck here. I have a smartsheet (Survey Responses) that contains data from form responses from a survey. The data is synced directly from Google Forms into Smartsheet. (See below.) I have created another smartsheet (Survey Data Points) to compile data points for metrics and reporting, which contains various…
-
Return a string value if cell is under, over, and between certain values (IF) function
I'm trying to get an IF function to work in the Health column of my sheet using the following logic: If budget used cell is less than or equal to 74, return "GREEN" If budget used cell is between 75 and 100, return "ORANGE" If budget used cell is greater than or equal to 100, return "RED" I am using the below function:…
-
Index; Match formula - 1-5 star defaults
Hi everybody; it is always a happening when huge formula is working as the following one: But for any reason the formula works when I set "Kundenrelevanz" to 1,2 and 4 stars but if I change to 3 or 5 stars there is "no match" Any idea why it is ... ?
-
Fomula cross sheets | lead scoretable
For any reason this formula does not yet work properly. Has anybody an idea? Furthermore, do you have proposals for more KPI´s or sheets you can share?