-
Predecessor Logic for a Specific Day of the Week
I am working on a project plan template that has a lot of dependencies enabled for dates, and many of them need to start or end on a specific day of the week. I have searched the community and see a lot of questions on this, but do continue to see that it has not been developed as of yet. I did try to search within the…
-
Average for both columns
I have a dropdown columns with several choices and each choice represents % complete. The idea is to get the Circuit % complete for 1st and 2nd circuits columns but also It has ‘N/A” that will not count. It only count the column that doesn’t have it. This is what I tried: =AVG(IF([1st Circuit Status]@row = "Assigned to…
-
Progress Bar Date Automation
Hi All, Could someone help me figure out a formula for the progress bar column style. My goal is to determine how close (by progress bar visual) are we to the "target end date" of a task. For example, my start date is 01/09/2022 and my target end date is 30/09/2022 and the actual date of today is the 29/09/2022 so we would…
-
Average formula with error should give a blank cell
I used this formula below to give me the "DOC % Complete" but it is missing something. If the cell has “Cancelled” the Docs % Complete column should be blank but right now is giving me 50% =IFERROR(AVG(ISDATE([Design Circuit Recommendation Actual]@row), 0.5) + IF(ISDATE([Design Velo Recommendation Actual]@row), 0.5), "")…
-
Combining/Summing Contacts from Multiple Cells in a Single Cell
Greetings, In a Contact Column, and in a ancestor/child relationship, I would like for parent rows to summarize/list all persons in the child tasks. Is Smartsheet able to perform this action? E.g. If the child records list: * John D * Claire H * Emily G I want the parent to show: * John D, Claire H, Emily G. I have tried…
-
Adding months automatically
Hi all I am trying to automatically add a 6 month review date to a start date, it is working fine until a start date is past June, to which I get a #invalid value error. The formula I am using is: =DATE(YEAR(A2),MONTH(A2)+6,DAY(A2)) So 1/6/19 becomes 1/12/19 but if I try with 1/7/19 I get #invalid value instead of 1/1/20.…
-
How to enter specific text if the cell contains a partial match?
My If statement: =IF(OR([Task Name]@row = "Discovery", [Task Name]@row = "Analysis", [Task Name]@row = "Build", [Task Name]@row = "Test", [Task Name]@row = "Deploy", [Task Name]@row = "Design"), "PMO", IF(OR([Task Name]@row = "PER", [Task Name]@row = "PRT", [Task Name]@row = "CK1 RTS", [Task Name]@row = "CK2 RTB", [Task…
-
How to Consolidate Entries from Multiple Forms
I've seen this question asked before, and the same answer is always given, "use an update request." Is there a way to consolidate information, because I don't think update requests are the best solution for our process. I have multiple forms with different types of information being entered at different times by different…
-
Project Schedule/Milestone Tracking Solutions
Hi Everyone! Does anyone have a project schedule/milestone tracking solution to share? I'm trying to create a company wide solution to input/track schedules for multiple projects, multiple milestones within each project, and provide executive level visibility of the status of each project. Any good ideas would be…
-
All Dates populate based off one date
Hello, I am trying to create a sheet where I can put in one date in the Target Start Date column then all other dates populate from that date based off the duration it takes to do all the task. Is this possible?
