-
Recurring Tasks
Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would format their sheet to account for this. For example I have a task that needs to be done the Monday following all major holidays…
-
Count Every Time Two Specific Dropdown Items are Chosen
I have a dropdown list in a column named "Status" where we track the progress in a process. The dropdown list contains the following choices: Initial Testing Ready for Review Ready for Retesting Ready for 2nd Review App Support Request Submitted Completed ON HOLD No Longer Needed I'd like to count the number of times that…
-
The sum of values in the next row
Hello everyone, I'm having difficulty writing a formula and would like to ask for your help. If in the fourth column of the image below, a risk condition has been identified, I would like to sum the values below the row where the risk was identified, without including the row classified as a risk in a new column right…
-
What am I doing wrong in this formula?
=IFERROR(INDEX(COLLECT({Master Unit/Manager List WI Range 1}, {Master Unit/Manager List WI Range 2}, [Site]@row, {Master Unit/Manager List WI Range 3}, [Department Name]@row),[{Unit/Manager List WI Range 4})) My goal with this formula is: if SITE and DEPARTMENT Name on Sheet1 matches SITE NAME and DEPARTMENT NAME on sheet…
-
Department Helper Column Rollup Multi Select
The goal here is to create a helper column that with a formula will grab the department information from each task row, and then roll that up into the parent phase and project rows. However sometimes there is a department in the parent rows that are not in the task rows. So I need to be able to grab information from not…
-
Count is not blank
I am creating a sheet summary. I would like it to count only those in January and my column range cells are not blank. I feel like I am so close. =COUNTIFS([Audit Month 2]:[Audit Month 2], "January", NOT(ISBLANK([Test Issue 1]:[Test Issue 4])))
-
Cant figure out Summing 2 columns based on text in another
I'm trying to sum up two budget columns, based on the budget type in another column. For some reason I keep getting errors and can not figure this out. =SUMIF(Program:Program, "BDM", [PO Raised]:[Planned, not POd]) Program Column = Text/Number = "BDM" PO Raised & Planned, not POd columns are also text/number columns that…
-
Row Report Custom Filter: Allow Basic Formulas to used to Filter Data
Current Build: When Creating a row report, you can filter by Column data. Example: "Month = 3" or "Percent > 75%" Concept: I want to be able to apply basic Formulas to custom filter data. Example: Month =Today(-31) or Percent > AVG([Average1]@row, [Average2]@row) This would reduce the amount of times you would need to…
-
There has to be an easier way...
Hi smarties, I have 40 metric sheets (one per location). In each sheet I have an countif formula that references a data sheet. I have this formula in about 20 columns. A sample is in the screen shot. It says something like count if the name in the Frontline leader column of the metric sheet matches the name in the data…
-
Parent Row Schedule Health functionality
Hello, I have a column formula that is returning random results, mostly on parent rows. The formula is: =IF(Status@row = "Complete", "Green", IF(OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "On Hold"), IF(ISBLANK([Target End Date]@row), "Red", IF([Target End Date]@row < TODAY(), "Red", IF([Target…