我在想如果有一个n easy way or best practice for this... We do many of the same type of project (all same tasks, assignments, etc) for different 'builds'. We have a project template which contains all the proper columns, etc. including assigned to. When we have a new 'build' we simply save the template as new…
I apologize in writing this as I am extremely frustrated... this community has been amazing but my experience with Smartsheet support has honestly been the worst support I have encountered in a very long career dealing with many support organizations. So bad I am considering canceling my account and moving on to another…
Hello Community, Having trouble coming up with a solution for this. I have a sheet with a bunch of data and many sheet summary fields. The fields are mostly counts or sums of rows based on a criteria. Like a count of how many rows with a checkbox column with a check. A have a dashboard which shows all the needed info. This…
I know this has been discussed before and I've read several posts but I'm still having some trouble and I'm sure it's really easy for the experienced folks here. Referencing the diagram I am trying to turn the star column on with the following logic: If % Complete = 100% AND RA Status = "A" or "B" then turn star on. I've…
Hello Community, I am brand new to SmartSheet (and not much experience in Excel either) but I was tasked with a problem to solve that I'm having trouble with and could use the community's expertise. Referencing the attached, I need to do 2 things... I need to calculate the cells highlighted in yellow based upon status and…
Hi Community, I'm trying to figure out if I can automatically add a row with data to a sheet (say Sheet B) when a value in Sheet A changes. The concept is if an escalation/issue arises, automatically create an entry in the issues/escalation log (sheet). But I don't want to simply copy the row - I want to create a new entry…
Hello, using the Active Projects report in PMO Template Portfolio view... Is there any way to get milestones to show on the Gantt timeline? I know you can drill down and get milestones report, put it in a separate project level view, etc. but wanted to know if there was a way to show the milestone diamonds on the rollup…
