-
Multiple IF Statements
I am using the following formula which is correct and working as expected =(IF([Panel Type]@row = "P", ([Total Cost for Mediation]@row * [Panel Fee %]@row))) However when I try to add in another IF it stops working =(IF([Panel Type]@row = "P", [Total Cost for Mediation]@row * [Panel Fee %]@row)), (IF([Panel Type]@row =…
-
Issue with #INVALID REF in formula
Hello, I am trying to create a calculation that will then be used for a metric widget on my dashboard. I want to be able to have metrics for different groups of projects by state. My goals is for the formula to only count projects that have "P2P(Department)" in the Department column of my portfolio metadata sheet. I have…
-
Need assistance with the following COUNTIFS formula
I am trying to count a status in one column (Last minute shipment set up) across MULTIPLE people in another column (Director). I created a working formula but it only tallies the status in one column across ONE person in another column: =COUNTIFS([Director]:[Director], "john.smith@help.com", [Last minute shipment set…
-
Creating a Milestone Sheet (referencing project plan)
Hi All, I have created a project plan in Smartsheets and am tracking milestones using tags How do I create a separate sheet which only shows me milestones, its start/finish (i.e start=earliest start date with a particular tag, and end=latest end date with a particular tag), its % completion (based on the milestone tag) and…
-
1 Symbol is not updating with fomula
I am using the RGB balls for tracking tasks. I have red set to activate if the date in the finish column is in the past. The other 3 color denote status of the task. Formula: =IF(Status3 = "Not Started", "Gray", IF(Status3 = "In Progress", "Yellow", IF(Status3 = "Complete", "Green", IF(Finish3 < TODAY(), "Red")))) GRAY,…
-
Help with Roll Up formula
Please help! I have a formula in my status column that works with the exception of one scenario. If I have say 5 children and of those, 4 with a status left blank and 1 that is "Complete", it is rolling up to "In Progress" as I need it to. When it changes to more than 1 "Complete", it rolls up to "Complete." If there are…
-
Updating parent row with data from all children rows
I am trying to update a parent row with the data found in the children rows The following formula works =[Check Number]2 + "," + [Check Number]3 however, I have some parent rows that have more than 2 children beneath them Is there a formula to use the parent/child relationship to get it to include all data from the…
-
Find matching criteria, take costs, add, provide total.
Howdy, I am attempting to create a sheet that can consistently provide totals from adding up all costs on lines that have matching IDs / names. I'll explain below: >Sheet contains multiple projects lines. We'll call these projects A and B. >Projects A and B have multiple, not collected together, entries with costs…
-
Formula to identify whether or not a project starts or ends in a Quarter
Hello, I have columns for each quarter of the year (Q1, Q2, etc.) in Checkbox format. I am trying to create a formula where the Checkbox is automatically checked if the Start Date and/or End Date fall within the quarter. For Q1, I only need to look at the start date because all of the Start Dates are in 2022.…
-
Date formula that excludes Saturday & Sunday
Currently I have a formula that calculates project due date - 3 days =[Bid Due Date]@row -3 What formula can I use to exclude Saturday & Sunday ?
