-
Help on formula: countifs with multiple criteria
Hi everyone, I need help on the below formula. I am trying to get the number of active projects based on the columns Section and Stage (see attached image). The 2 sections are called Food and Non-Food. The active stages are called Planning, Strategy Decision, Tender, Evaluation and Contract. Other terms applied in this…
-
Formula in parent row for updates in child rows
Hello! I have my sheet set up so that all of the update columns in the child rows are automatically a red dot. Once a row has been updated the cell turns to a green dot. It will stay green for 4 days as I have the formula set up so that on Mondays I can see if any PM's have updated the sheet since Thursday (4 days…
-
return list from another sheet
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries. Thanks in advance!…
-
Nested IF Then And Statment
I am trying to finalize a Nested If Then /And Statement. In one of my logical functions, I am trying move to the next condition if a cell has a date input into. When I try to use the logic if cell > 0, it returns an error. What would be the best method for moving the formula to the next logical statement?
-
SUMIF IF referred sheet/column ISDATE
Hey everyone, working on something that i am having a problem with I have the following =SUMIF({FSM - Help Desk Ticket Tracker Range 4}, $VlookupValue@row, {FSM - Help Desk Ticket Tracker Range 1}) This returns the value from the cell that i want to perform a specific calculation. I want to add more to this though. The…
-
SumIf contains certain text--use FIND?
Sorry, I tried to search the archives but couldn't follow the examples so am hoping someone could help me with this specific scenario. I am trying to put together a budget that is summing up columns that contain certain text. I would like to figure out how to sumif Row 3 all columns containing the term "grant" so that I…
-
Excel Formula Error
Hi All, I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas: =COUNT(IF(FREQUENCY([Listing Key]2:[Listing Key]20)>0,1)))) The "[Listing Key]2:[Listing Key]20" reflect the chosen cells to crunch the formula. Attached is a…
-
Counting the number of row with dates
I have been asked to provide some stats on the number of live and outstanding jobs that are due. The due dates for each job is the last day of each month (30/06/18, 31/07/18, 31/08/18 and so on). I would like to get a count of the number of jobs that are still outstanding from each previous month and i am not sure how to…
-
Importing Excel formulas "#UNPARSEABLE"
When trying to import Excel including following formula: =IFS(J3<0,2;1;J3<0,4;2;J3<0,6;3;J3<0,8;4;J3<=1;5) I get and error message in Smartsheet. #UNPARSEABLE" Following show up in Smartsheet. =_XLFN.IFS([Growth %]1<0.2,1,[Growth %]1<0.4,2,[Growth %]1<0.6,3,[Growth %]1<0.8,4,[Growth %]1<=1,5) What the formula dose in Excel…
-
Multiple Countifs and Children to use in a Dashboard
Hello Everyone! I'm new to figuring out counts in SmartSheets and Dashboads/Sights and could use a little help. I have a sheet that is connected to Salesforce via the Salesforce Connector, so the data is dynamic. I currently have the sheet grouped by department. Under each department are children rows for projects. There…
