-
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?
-
Is it best to link only one predecessor to each task or is it ok to have multiple?
I am working on a construction schedule and wondering what the best practice is for attaching predecessors. I have noticed my Gantt chart is currently a bit all over the place and I am thinking it is because I have too many predecessors for each task. Do more experienced Smartsheet users recommend only having one…
-
Excited to Implement Work Apps
I’ve learned a lot at the conference, but I’m most excited to implement Work Apps with the teams I work with. A one stop shop of all the necessary information will help improve their efficiency.
-
Very ENGAGING at #Engage2022
Having so much fun and learning all the things at Engage 2022 in Seattle!