-
IF, AND, OR Formulas
Using my data set, I would like to know by region the number of multi-year reporters and new reporters (2018). I will count either status as an active reporters. Ex. Africa= total 2 active reporters -Ghana: Multi-Year Reporter -South Africa: New-Reporter -Nigeria: Did not report The following formula will count the number…
-
Summary Task status - automatic
Hello, Im very new to smartsheet, so, im sorry if this question is too "basic". I have a summary task with 3 or 4 children tasks. I would like to know if there is any way to automatically update the status of the summary task: - If all children are completed --> completed - If any children is on-going --> on-going An the…
-
IF or IF AND Formula conditions DATE
Dear, I appreciate your help. I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019) 1) If the Balance column is equal to 0 (Green) 2) If the Balance column is less than 0 (Yellow) 3) If the Balance column is…
-
Identify duplicate dates and exclude blank cells
I am working with a SmartSheet that is used by multiple people to schedule meetings. I am trying to check for duplicate meeting dates within two columns "Proposed Date" and "Proposed End (if multiple days are needed)". Dates are entered in rows 7-28. I have added a checkbox column titled "Duplicate Date" to be checked if a…
-
How Nested IF can I get?
I have a desire to change a Status column based on whether (or not) certain separate (other) columns are populated with a date. Is this supposed to work? All of the Nested IF examples I have seen tend to look at just a single column to evaluate against, and I'm wondering if I'm going to be able to make this work, and using…
-
Index or Vlookup or What?
Hey All! I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am wanting to pull data from the Budget cell based on the Job ID and the Cost Category. I'm not sure if it is a Index - Match…
-
SUMIFS with 3 conditions
Hi I am trying to calculate the total number of worked hours within a week/ month which match 2 more criteria. At the moment I have fr the monthly formula 9 September): =SUMIFS({003 Project Timesheets Range 2} , {003 Project Timesheets Range 1,"Noemi K", {003 Project Timesheets Range 3} , "Testing" and ({003 Project…
-
Calculate days between two dates w/o weekends
Hello all, I need to calculate the number of days between two dates (neither of which will be today), without including weekends. Does anyone know how to do this? Examples are listed below EX: 09/09/2019 - 09/08/2019 = 1 EX: 09/16/2019 - 09/13/2019 = 1 Any help would be much appreciated! Many kind thanks!
-
IF Statement - If two columns match any two columns on the page, flag it
Right now I have =IF(COUNTIF([Part Number]:[Part Number], [Part Number]1) > 1, 1) If the part number in row matches up with another row, it lights up a flag. I want to be able to add two checkpoints... If a "part number" and "ware" in one row matches up to another "part number" and "ware" on a different row, light up the…
-
Combining 2 Formulas
Hi, I have a column that is calculating today minus a date that is in another column. I have another column that is taking the days and converting it to weeks. Then i have another column that is taking the weeks and rounding down to 1 decimal point. Is there a way to combine the column converting to weeks and the column…
