-
How can I get this formula to work
Hi, I still have a lot to learn in Smartsheet, but I have been using co-pilot to assist. However, I need help with this formula that I cannot get to work. My goal is to strip the site names off any special characters expect for the first four letters# and "offnet. I'll appreciate the any assistance that can be provided to…
-
Use dependencies to set start and end dates independently
how can i use dependencies to help set both a tasks start AND end date independently (not using duration)? As an example, i would like row 3 start date to be row 2 start + 5 (I can get that by setting predecessor = 2SS+5), but I want row 3 end date to autopopulate with row 4 start date.
-
Batch Sheet Creation from Template
Problem: Current Limitations Manual Repetition: Provisioning a large project (e.g., 50+ distinct team sheets) currently requires manually executing the "Use Template" or "Duplicate Sheet" workflow 50 separate times. Time-Consuming Setup: There is no native bulk-action to instantiate multiple files at once, creating a…
-
How to combine multiple project plans into one, but keep separate editing access?
I am running a program that contains 17 different workstreams, and each workstream has a separate PM that is running their own individual plan. We want a view where you can see all of the workstreams together in a 'program' plan. We consolidated all plans into one but this has created a large number of issues as we have 20…
-
Predecessors Drop down list like MS Project
It would be a tremendous help in creating and maintain project schedules having the dropdown like in Project for selecting Predecessors it is very time consuming to have to jump out or have a second screen open to fined what needs added. This would be a huge help in schedule creation and monitoring.
-
Override formulas and hard code cell values once a row has been locked.
I'd love to have a condition where cells or columns are hardcoded or locked once critiera is met. Currently the lock feature does not override any formulas, so values can change within a locked row should a formula trigger a change. This defeats the purpose of a locked row in my opinion. Since we have many helper columns…
-
Lookup Value and Count based on the input criteria
Hello Team, I am trying to bring a formula to look up a value and bring the corresponding counts. The input sheet will look for the "Date of" column and dynamically generate the Yesterday or Today value based on the formual i have written for "Yesterday/Today" column. There is a person going to enter #New Hires, #Leavers,…
-
How are you scaling a PMO in Smartsheet across multiple departments/workspaces?
Hello everyone! We have a great structure within our own department and looking to expand across our firm. I am looking for insights on how you manage cross‑department projects when each department has its own workspace? Interested in workspace structure and reporting best practices. I appreciate the help.
-
Merged: Workback Schedule
This discussion has been merged.
-
Project Plan Backward Scheduling / Planning
Implementing backward scheduling in Smartsheet would significantly enhance its utility for project managers who work with fixed deadlines and need to calculate start dates based on a target completion date. Backward scheduling allows users to plan by defining end goals and identifying the necessary steps and timelines to…