-
Summary Sheet
In my project schedule, I have several columns including the following: - progress (on track, at risk, behind schedule) -functional area (dept1, dept2, dept3) -status (complete, not started, in progress) I'm trying to create a summary sheet that tells me : Overall % of on track, % of at risk, % of behind schedule Dept1…
-
Formula for parent row that calculates % of child rows, based upon date durations
Hi all I use a manual formula in my parent rows to calculate % Complete, because we chose to have the % Complete column update automatically based upon the Status column ("Complete" = 100%). The parent rows have the following formula: =IF(OR(Status@row = "Complete", Status@row = "Not Required"), 1, AVG(CHILDREN())) Which…
-
COUNTIF CREATED SYSTEM COLUMN
can someone please assist with this? i am trying to count # of days in the created date system column for August 17th & August 18th my formula is not working
-
Counting blank cells when the column is being used for roll up metrics in another sheet
Hi All, I'm working on creating dynamic metrics using a roll up metrics sheet. I'd like show the total number of tasks for each status and the total that has no status assigned. Easy, right? =COUNTIF({Column Name},"Status Type") or =COUNTIF({Column Name},"") the problem is the total number of tasks by status type exceeds…
-
Tasks due within # of days
Sorry I know this is silly but can't figure out the formula looking at examples. I want a value returned if 'target end date' is due with 7, 15, 30. I have this working but can't seem to figure out how to add the additional criteria to include the other values. The values I want to return are just looking at Target End…
-
Workflow becomes invalid after each trigger.
Hi, I am also facing the same issue. I have set the triggering point to Modified date which is Auto/System Generated Date Column. This is so because my requirement was whenever any changes are done in form, approval request should get triggered. Since we are not sure, what column user is going to change, we kept the…
-
Count of Dropdown (multi-select) items in another sheet
I have a sheet that has a column called Steps, Values Step 1, Step 2,...Step 10 From another sheet, I want to count how many Steps happen in a Stage (which contains a number of Steps) I would like a count formula that looks at the Steps in each Stage and counts how many rows in the other sheet have those Steps in it. I…
-
Max of Children Formula
Hi Formula Friends - I'm trying to calculate the "next test date" based whether a cell is "Surveillance (Monthly)" or "Baseline (Initial)" or "Response (Weekly)". In the formula, it must take into account the following: If Test Strategy in Parent Row = Surveillance (Monthly) or Baseline (Initial), then the Next Test Date…
-
Is the Today function actually being forced to update?
The grid below shows 3 rows. The 1st, Header_Row, is a place holder row for the Today function entered in the 1st cell of the Date.Today column. This allows the formula to be copied down when subsequent rows are added to this Smartsheet. Using automation, the "Delete_Task" row is copied into this sheet from another source…
-
Validate duplicate with 3 variables
Hi guys, I have been working since days in one formula, what I call "cascate formula", to validate 4 variables to define if an event require attention or not. An event can only be validated, if there is NO other event assigned to the same trainer in the same time frame (start and end date). So, I have 4 columns (start…