-
COUNTIFS And OR
The formula below works, but I have a situation where I want to count when two different attorneys are listed in the Attorney field. =COUNTIFS(Attorney:Attorney, ="Attorney1", [Contract Status]:[Contract Status], OR(@cell = "Customer Legal Review", @cell = "Pending PAC", @cell = "Pending SRTC", @cell = "Sent for…
-
Adding multiple columns if one column equals X
I have a multi column sheet. If column Alone= CN, I want to total four columns. =SUMIF([$ Regular]:[$ Regular], [$$ xyz 2021]:[$$ xyz 2021], [Per Item $ 2021]:[Per Item $ 2021], [null 2021]:[null 2021], [Revised $$]:[Revised $$ ], (Alone:Alone, CONTAINS("CN", @cell)) I've tried ever iteration and I cannot figure it out.…
-
If all = Competent then competent, if not, then inconsistent
Hi all, I need help with a formula. People choose their skill based on a certain topic: Competent Inconsistent Expert I need a formula that looks at all the children and determines that: If 1 inconsistent, no matter what else, show as inconsistent If all competent or expert, show as competent I am guessing it can be easily…
-
Formula to find todays production
Hello Smartsheet Experts! Im hoping someone can help out here... :) We are attempting to see if we can get a formula that will give us todays production based on the percent complete? i.e. the project is worth $100 and on day we complete 20% so the value would be $20. Day 2 we progressed to 50% so our value for the days…
-
At months on to a date
I am looking to add months onto a date based on what is shown in the column highlighted in the screen shot. It is simple in excel using "Edate" but I can not seem to get it working in Smartsheet Thanks in advance
-
Countifs formula to count a value within a date range?
Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a particular date range in our calculations sheet to give us the survey results for that time frame. For example: I only want smartsheet to look at the surveys completed…
-
How do I copy a formula and update a cell reference
I'm an excel user, but new to Smartsheet so I'm still trying to figure out how it works. Please see screenshot attached for reference - I have a formula in the "Yes_2" cell (circled in red). That formula references another sheet "CSF Questionnaire Range 7" (highlighted yellow). Next, I copied the formula and pasted it in…
-
Self-updating report based on sheets in folder
Hi there, Is there a way that I can build a report so that when a new sheet is added to a smartsheet folder, the contents of the sheet then automatically gets compiled into a report? I saw that it was possible to select a folder when building a report, which I was really hoping would have that functionality. But it looks…
-
IF statement returns formula statement, not value of formula
I want the value if true, value if false in my IF statement to return the results of 2 different formulas. But if returning the language of the formula itself on the value of the formula. I need this cell to show how long a position has been open, and if there is a position fill date, how long it was open before being…
-
Nested CountIf function
Hi there. Is there a such thing as a nested countif function?? I'm aware of how to use the countif in smartsheet... =COUNTIF({ Test Sheet Range 3}, "Approved") Suppose I want to count records with more than 1 criterion? Status = Approved Stage = Stage 1 How would I craft that out? Is it a nested CountIF function?? Thanks,…