-
Formula needed - adding total of one column dependent on other columns criteria
I need the sum of one column conditional to the criteria of 3 other columns; below is the formula I am attempting to use with the goal of obtaining the sum of [% KRs Contribute to Corp Objs] that have the below additional columns criteria. Can anyone review and let me know if I need a different formula or what I am…
-
Hello, I've been trying to use unique values in one column to determine what the yearly sum is?
In the above screen shot, I want to use the Job Family value to add up any amounts that match for the year. I have tried SUMIF, SUMIFS, COUNTIF,.... I keep getting #unparseable error. Here is my formula: =SUMIFS(Program1:Program5, ="PAR", JAN1:JAN5, >0, FEB1:FEB5,>0, MAR1:MAR5, >0, APR1:APR5, >0 MAY1:MAY5, >0, JUN1:JUN5,…
-
How to include Paranthesis in formula.
I am using an IF formula in a Total column Column A A) Option 1 B) Option 2 Total Column = IF ([Column A]@row = "A) Option 1" , "3", IF([Column A]@row = "B) Option 2" , "5")) I am getting error, as ) is prematurely closing out the computation. Any help is much appreciated. Thank you, Deepthi
-
RAG Calculation to highlight Red, Green and Blue balls
I cannot work out how to combine the following arguments into one cell and calculate, i have spend hours trying and getting no where, would appreciate any help. The following will return a red or green to the RAG column and works perfectly : =IF([Baseline Variance]@row <= 0, "Green", IF([Baseline Variance]@row >= 1,…
-
Complex COUNTIFS and IF Function
Hello, I need help putting together a function that can count certain cells in my grid. The inputs of the function are the following: If Beta is "Yes", it should be counted twice If Beta is "No", it should be counted once But if the Primary Region Column is not checked, the row should not be counted at all. Beta is a…
-
Checking box if form submitter has selected certain options from a multi-select drop down
Hi, I am new to Smartsheet and have a form where there are about one hundred options in a multi-select drop down, they are subjects of expertise the person could speak on. 15 of the options are in the technology category of expertise. I want a checkbox to be automatically checked if the person selects one or more of the 15…
-
Saving column selection in update requests
Hallo, when I want to send an update request I always have to deselect a number of columns before I can send the request. Wouldn´t it be nice to save different settings f.e. department 1, client 2 ? What do you think? 😉
-
Assign Ownership to A Group
Hello, Can ownership of a sheet be assigned to a Smartsheet group? Our goal is to have the email notifications display the group name as opposed to the individual owners name. Thanks!
-
Need to Count Unique Values Based on Criteria from a DropDown Collumn
Hello, I need a function that can identity duplicates and determine if they should be counted as one or more than one depending on criteria within another column of the spreadsheet that is a dropdown. The specific context is there is a Name Column (Column A) and a Dropdown Column (Column B), Column B has three options "Yes…
-
Help with RYG IF Statement and consider a Blank Cell
I have a sheet to measure KPI's for a project. Bascially I'm trying to record when we submit a report; If the Submission Date falls before the 4 Week Limit (Purple Helper Column) KPI 2 returns Green If the Submission Date lands after the 4 week limit but less than 14 days 'late' KPI 2 returns Yellow If the Submissinon Date…
