Project Management
Discussion List
- Hello, I am trying to create a formula that will collect the min. date for the resource listed at row for various projects. If the resource isn't listed as a task owner, Right now, I am getting a blan…
- I am trying to figure out how to have certain cells auto fill with a generated date if a certain category is selected. Example: If "communication" is selected, I need a cell to auto fill with a date t…
- Hi Community, Are you tired of having to manually go into each role and set individual permissions whenever adding a new page to WorkApps? Not anymore! Smartsheet’s new features now allows users to se…
- I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the…
- I need to calculate the planned date against the Go-Live date for each column. The dates are above the columns that should be prior to the Go-Live Target which is 10/31/22. I need to make the actual c…
- How would I calculate the time between two dates (start and finish) in Weeks and Days "8weeks 4days"
- I have several columns with dropdown (Complete-Go, Incomplete, TM Approved-Go) and one column that says (Go/No Go). If all columns have "Complete-Go or TM Approved-Go" the column (Go/ No Go) should be…
- I have a dropdown list and I want to put a value for each item (but not in the list): Not Ordered = 0% complete Ready to Order = 1% complete Order Process = 20% Shipped = 50% complete In Country Custo…
- Hello, Is there a way to conditionally format duplicates if a value is in a column and if a box is checked? I need this to look through the whole sheet where there are many input values by the custome…
- I need to count total entries from another column from another smartsheet minus out scope criteria. i.e. 1st Smartsheet, column 1 Title “Total Sites in Scope” 2nd Smartsheet, Column 1 Title “Site IDs”…
