-
Percentage Complete of child tasks
Hello! I'm trying to figure out a formula to do the following: 1.) Display percentage complete of tasks marked "complete" within a child group, at the child top level 2.) Display percentage complete of child groups in the parent row. Note that I am not using dependencies, and am using an independent "% complete" column (I…
-
Last value of a row that is not empty
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history of the data. columns (date type) can contain a value or be empty. I need to get the last updated date for each project (not…
-
How to calculate hours for tasks marked 100%?
Hello, In my Sheet I have a column for Task % Complete and another column for Total ETS Effort. The Total ETS Effort column contains the number of hours associated with each task. I'm trying to figure out a formula that would give me the total number of hours for each task that is 100% complete. Any help would be greatly…
-
Project Completion %
Hi! I am pretty new to Smartsheet and am building my first project template. I've got tasks in rows 21-169 and I am trying to build a formula to calculate the total completion of the project, taking into account the durations set for each row. The rows are also indented into phases and milestones. Any help or direction is…
-
Help with IF Statement with multiple SUMIFS
Hello, I am trying to sum up a range of data from two spreadsheets based on the same criteria. Here is my formula which is throwing an #UNPARSABLE error and I cannot understand why =IF(SUMIFS({Advertising Total Cost}, {Hardi}, =$Region$1, {Year}, =2021, {Month}, =[OCT-21]$1, {contract}, =CATEGORY@row) AND(SUMIFS({misc…
-
Decrement a funding total
Hello all you formula wizards ~ I'm down to the last test of a travel request module and I realize my formula is not working correctly so I'm looking for some guidance. I have an intake sheet where requests are submitted, then reviewed and approved, which moves the data to another sheet for further approvals. I need to be…
-
Flag task as late where task incomplete and past due date
Please help, I am trying to flag late tasks in a column using the following formula... I am getting a #INCORRECT ARGUMENT SET error...Please help =IF(AND(Status27 <> "Complete", (Finish27 < =TODAY()), "red")) thanks
-
Help with (date) helper column anomaly
I am using a helper column to provide a date from 'Date created' column that auto adds date and time. The helper column date can then be used to calculate days btw it and today. I am using the formula =DATEONLY([Date created]@row) but the helper column shows the day before as in the screenshot below. I have experienced the…
-
Hi All, I have a question about COUNTIFS()
The scenario: I am trying to count only the rows that meet two criteria. This sheet tracks requests for headcount by type and by year. So there are two columns among the data, one that states the year requested, and one that states the type requested. I have two ranges, one for each column in the formula. Each range only…
-
Archiving rows with formulas that reference other sheets
I've build a pretty large Smartsheet for tracking data yearly contracts for each of my 60-70 clients on therapy caseload with formulas in each row that reference other sheets and pull numbers from daily log forms. I need a simple process for archiving a row when the year contract is complete. I want to save a snapshot of…
