We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards.
Prefer local to Charlotte NC but open to telecommuting.
I have a series of standard processes that have the same dependency and predecessor data each time.
I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.).
If pre-assembly is selected, for
I want to get the sum for only the dropdown value selected:
Here is the Situation:
First Column: I have 3 Resource Type:
Column 2: I have resource Name
Column 03 to 35 is a Hour Cloumn ( Where it shows how mnay hours each of my resource is available to work)
I have been trying to figure this out for hours with no luck. We've created a formula to automatically update our status column in our project plan sheets. We have specific parent rows that are designated as milestones. The milestone row status cells should update based on the status of the child
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum
I am having an issue with creating a formula that will count a column if a row has a date in it. It can be any date just as long as it has a date. PgM Status is the column with the date right now I'm just counting the section that has the dates but would like to create a formula, so I don't have to
I want to use smartsheet as an international project management tool. One thing is driving me creasy.
I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.
The task in row 27 needs row 25 & 26 to be done ( active
I currently have a sheet populated via a web form. There are several people assigned to tasks.
My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible.
I was working on a way to track some task hours and minutes... came up with this:
One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore