-
Formula Help
Hi, Need help combining these two formulas to calculate the # of days open from the date of entry. Not to include "Solution complete" or "Solution identified and agreed upon". =IF(NOT(Status@row = "Solution Complete"), (TODAY() - Date@row), "") =IF(NOT(Status@row = "Solution identified and agreed upon"), (TODAY() -…
-
COUNTIFS multiple criterion
Hi All, Maybe somebody could help me to figure how does COUNTIFS formula works? I am trying to get summed cells which has specific naming from the drop down. I want to count "Dismounting" cells only if Column "Done" is not checked. At the moment I am typing formula in this way: =COUNTIFS({Type}; "Dismounting"; {Done}; "0")…
-
Sumif with Children
I want to do a sumif based on the value of one column, but only get the children tasks so the summary tasks are not included in the sum. I can get the sumif to work fine; I can get a sum(children()) to work fine. However I can't find the right syntax for the =sumif(col:col, 1, children()) Does anyone have an example of…
-
Recurring Weekly Tasks Formula
I have a sheet set up with a weekly task, a column for last completed date, and a column for next due date. I have a column that indicates the day of week that it must be completed on. I am trying to set up a formula in the next due date column that uses the selected day of week to update the next due date based on the…
-
SUM 2 COUNTIFS functions #INCORRECT ARGUMENT error
I am trying to sum 2 countifs functions and I am unsure why I am getting an error. I was hoping someone could help me fix this error. =SUM((COUNTIFS({Jade3_BCM Dashboard 2019 Range 1}, "Examine & Validate", {Jade3_BCM Dashboard 2019 Range 4}, "Execute on Timelines", {Jade3_BCM Dashboard 2019 Range 3}, "1st Quarter")),…
-
Date from Week Number
Is it possible to get a date (mm/dd/yy) from a week number? Ultimately I'd like to get the Friday of the week number. Using today as an example (1/11/18), the week number is 2 and Friday is 1/12/18. I've tried some different Excel formulas but am not getting anything to work in Smartsheet. Thanks!
-
Count if formulas
Hello, I have a fairly simple formula that I need assistance with. I have a 'Date completed' column (UK Date format) and a check box column, 'Test1'. I want to do a count in a separate cell for all the rows that have check boxes ticked for within specified month period. E.g. Count the number of test completed in May. I…
-
Will SUMIFS work with a date and a checkbox?
I am trying a SUMIFS formula without much success. The formula needs to return the Distance if Completed Date is before 31/03/20 and Signs has been ticked/checked. Distance (number) Completed date (date) Signs (checkbox) Is this possible? Thanks Faz
-
How do I reference different columns from another sheet in different formulas?
I am creating a sheet with formulas that include ranges in another sheet. The ranges are defined by column. It seems I can reference only one column across all formulas in my sheet. Whenever I go to change the range in one formula, it automatically plugs that same range into the other formulas. How do I create multiple…
-
IDEA: Create Cross-sheet references from reports
Just want to throw this out there. I am referencing three rather large sheets and trying to bring in some COUNTIF data but keep getting told that I am referencing too many cells. This is prohibiting me from creating the data I need. It would be great if you could do cross-sheet references from reports. This would allow me…