-
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,…
-
Formula
I want to include a column, On Hold, a checkbox (0,1). If it's checked, I want the State to be "On Hold", with another formula that enters State depending on two other cells - Status (RYGB) and % Column. Unchecked and it should follow the rest of the formula. How do I combine them? =IF([On Hold]@row = 1, "On Hold")…
-
No of CVs sent by role and month
Hi all I’m trying to create a formula to show the number of CVs sent by month and role So number of CVs for Delivery Managers for October (pic below) is 18 but how I do I get this from a formula? I can get the number of CVs for all of October using a simple =SUMIF formula but when I trying adding in the role, it breaks!…
-
Current Year Month in a count formula
I'm having problems finding the right syntax to count the number of records for the current year month. My sheet may have records from several past years but I just need to count the number of records by month for JUST for the current year - even if I must update the formula each January - that's ok. My basic formula for…
-
Cross Sheet AND Formula
Hello! Trying to put together a formula looking at two columns on a different sheet. the Logic is if, Range 5 is blank and Range 4 is blank = number. Keep getting unparesable. =COUNTIF({Tracker Range 5}, "", AND{Tracker Range 4}, "") Thoughts? thanks!
-
COUNTIFS Unparseable
I have two formulas that are currently returning correct values, but I want to combine them and only return the count if both criteria are fulfilled: =COUNTIF({Approved Avalara Fixes - Form Required Range 1}, "Name") =COUNTIF({Approved Avalara Fixes - Form Required Range 7}, NOT(@cell = "Child")) Above are the two formulas…
-
Multiple sumifs
=SUMIF([Platform Site]@row, CONTAINS("eBay", @cell), Net@row - [PayPal Fee]@row) =SUMIF([Platform Site]@row, CONTAINS("fsx", @cell), Net@row - [Platform Fee]@row) These work independently but I need them to work together for a column formula. When I try to put them together, I keep Error messages. Help. I have to have this…