-
Formula Help- Calculating Costs
Hello, So i have this formula: =COUNTIFS({Environmental Incident Tracking Range 3}, "1", {Environmental Incident Tracking Range 7}, =(2020), {Environmental Incident Tracking Range 5}, "R507", {Environmental Incident Tracking Range 1}, "Leak / Fuite") But i need it to match this criteria, but calculate the cost accumulated…
-
Time formula: how to add 4 hours to my appoint time column?
Hi, I have a appointment time column and I would like to use a formula and add 4 hours to get the End time. Is there an alternative way to do it like sort of formulas? Kindly help, I need this to my report this week.
-
Weird behavior with MATCH
HI, I'm trying to build a scoring system but i've got some strange behavior from MATCH. What i finally did was putting all items in one new grid , the formula in another and this is what i've got? Formula under Strategic fit : =MATCH([Strategic fit]@row, {New Sheet Range 1}) Formula under priorities : =LEN([Strategic…
-
Changing Reference File
Hello, I have created these files: A raw data sheet - I will copy data extracted from various systems and paste them into this raw data sheet A sheet for metrics - a summary sheet for summarizing statistics from the raw data sheet Multiple reports for different purposes that draw data from the raw data sheet Multiple…
-
A single sheet that can pull data requested from sheet with Form responses
Hi, The end goal is a single sheet where someone can input something to pull from another sheet that was populated by form responses. Example using ice cream: Personnel completes form that provides how much they like different types of ice cream. And they use Harvey balls to select how much they like the ice cream. I want…
-
Formula to populate a 1 or a 0 based off of criteria
I have 6 columns where each of them will contain Yes or No. I want to know when a row contains all Yes's, and also when a row contains ANY No's. I added an additional column for "Approved" (for when all of the 6 columns is Yes), and "Denied" (for when any of the six columns is No). My end goal is to be able to sum those…
-
FORMULA - COUNTIF WITH 2 ARGUMENTS
Hi, In sheet summary I am trying to count total number of 'EVENT CATEGORY' that is 'STATUS' The formula I have tried is =COUNTIF([Event category]:[Event category], "Webinar" [status]:[status], "complete") Both columns are dropdown single select if that makes any difference. I am able to count by event category but adding…
-
Using LARGE with duplicate results?
Looking to find, for example, the 10 largest projects in our system by allocated resource hours. But what happens when there are duplicates/projects with the same number of allocated resource hours? =LARGE(({total hours}), n) From the result of that formula, in another cell, I then collect that respective project's name…
-
I want to find out the sum of a range within specific requirements based on salary.
I am looking to seek the capacity of resources using billable hours each month. For example, all resources that were available in February - what was the total capacity for billable hours, and so on for each month. I have the start and end dates in two separate columns with the sum of billable hours available and a column…
-
Multiple IF Statments
Hi Smartsheet Community, I have a question regarding multiple IF statements. What I am trying to accomplish: I am trying to put text in a box if the days are greater than or equal to the number of days since completion 0-30 Days, 31-60 days, 61-90 Days, 91-120 Days, 121-364 Days, 365+ Days. Current Formula: =IF([Total AR…
