-
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…
-
My Simple Nested IF() is not Working
I have done thousands of nested IF() functions much more complex than the example below but for some reason I cannot get this one to work. I'm using this formula in an archive sheet that determines what rows of the archive should appear in a report, just those that result in "Yes" in the Result column. Basically, if the…
-
Return a value if a cell date is between 2 dates
Hi, I want to automate one of my sheet summary by retrieving the Sprint# based on today's date. (When today's date is between the beginning and end of a sprint, I want the sprint# to be retrieved in the Automated Sprint field of the summary sheet). I have tried to use =INDEX([Sprint#]:[Sprint#], MATCH([Sprint start…
-
Using Sumifs and Month referencing another sheet
Hello! I am trying to sum the values occuring in a particular month referencing another sheet. Here's my formula: =SUMIFS({Summary Roll-Up - Machine Accepted}, {Summary Roll-Up - Machine Accepted}, >0, {Summary Roll-Up - Delivery End}, MONTH(@cell) = 1) The first part of the formula is working correctly, but when I add the…
-
Splitting data across multiple rows based on dates
Hi Everyone! As a Project Manager I would like to report total scheduled hours per week for an individual team member. Does anyone know how I can go about doing that in SmartSheet in a way that will update if the project plan is updated? I would prefer if this was performed in a separate sheet instead of the project…
-
Trying to Autofill filed with Text based on data submitted by form.
I am currently working on a sheet where pending on the multiple options they chose it field A it will Mark other fields as requested. Then once the resource is assigned we can mark as assigned. How do I do this in Smartsheet. I have tried some things but not sure what I am missing. Any help is appreciated.
