-
Assigning a value to a field
Hello. Could use some help / suggestions on the following formula. =IF(AND([Date Completed]@row = " ", [Due Date]@row >= TODAY()), [Past Due (Y/N)]@row = "True", [Past Due (Y/N)]@row = "False") I have a Due Date field, a Past Due flag field, and a Date Completed field. I would like this process to set the Past Due (Y/N)…
-
Days overdue count, only when Overdue Cell has Red Symbol
Apologies for asking what must be a very rookie question, but very fresh to Smartsheet and I'm stumped and can't find an answer in previous posts. I am needing to calculate days over due in my 'Help Days Overdue' cell ONLY if the 'Overdue' Symbol is Red. Any help here would be much appreciated while I try and bring myself…
-
help on formula.
trying to get this formula to work. NO LUCK please advise =IFERROR(WORKDAY(INDEX({delaware}, MATCH([Calendar Year]@row, {year}, 0)), {Holiday}, "")
-
% Completion Calculation Parent and Child
I'm have project smartsheet that I'm trying to figure out the formula for calculating parent % complete base on sub child completion percentages. Parent % Completed Child 1 % Completed Sub Child 1 % Completed Sub Child 2 % Completed Child 2 % Completed Sub Child 1 % Completed Sub Child 2 % Completed What would be the…
-
Sum a column where the value in the column is generated from a formula
I have a column (Column B) that returns a value based on a nested if statement; column A = x% Column B returns a value based on the % entered in column A. Here is the nested if statement: = IF([Allocation %]@row = 0.05, "2", IF([Allocation %]@row = 0.1, "4", IF([Allocation %]@row = 0.2, "8", IF([Allocation %]@row = 0.3,…
-
Group / Sum by Currency
Hi I have a report that groups and sums project by their respective allocated currency, e.g. USD / CAD etc. That works great however when I create the report it also shows the sum of the total; i.e. all the currencies combined. How do I hide that row?
-
how to count unchecked boxes from several columns
I want to count all the unchecked boxes in a row. get an error from this: =OR(COUNTIF([Reviewed/ No Edits]@row, 0, COUNTIF([Reviewed/ Edits]@row, 0, COUNTIF([Edits Submitted to GIS]@row, 0, COUNTIF([Edits Reviewed]@row, 0, COUNTIF([Zone Approved]@row, 0, COUNTIF([EVAC Status Updated = Approved]@row, COUNTIF([Summary…
-
How do I calculate a rolling average for the last 4 cells(that are weeks with Dates)? Thank you
-
How to calculate due dates based on 2 criteria fields
I want to have the due date column auto populate based on project start date and # of days for each category. Is this possible? So all tasks in project level rows would be due 30 days from start date, all EVAC tasks would be due 90 days from project start date.
-
Metrics - how to question
I want to change up how I am calculating metrics - currently counting tasks by team / completed tasks but this looks like not much progress is being made. Instead we would like to do this more by points or % of larger categories. For example: EVAC tasks would total 50% of the overall project, AWARE/community tasks, 40% and…