-
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…
-
Help With Collect Function
I have a sheet that has three columns - DueDate, Status and "Status by Color" respectively. Based on the entries in the status column the "Status by Color" cell is assigned the color Red, Green or Blue. My need is to identify the 5 oldest 'overdue' dates within the DueDate column. I achieved this using the following…
-
Can I use formulas to pull in hyperlinks from other sheets?
I want to use a formula to pull in hyper-links across formulas. I started with: =IFERROR(INDEX({Client Intake - Client Invoice Log}, MATCH([Client Name]@row, {Client Intake - Client Name}, 0)), "") but this only pulls in the text of what is in my client intake sheet rather than retaining the hyperlink to the sheet.…