-
Unexpected Two-Day Shift in Project Timeline When Copying from Microsoft Project to Smartsheet
I've encountered an issue where I'm copying all data from a Microsoft Project file into a Smartsheet project. Despite matching the duration, date format, and predecessors exactly, Smartsheet somehow adds two days to the project timeline, causing discrepancies. Does anyone have any insights into what might be causing this?…
-
Automatically have a project name <<project>> appear on each row
I would like to ensure that when an additional row is added to a project plan, the Project Name column is automatically populated with the project name. This name is pulled from the Control Center and is located under the summary section of the sheet. While I am aware that I can manually add the «project» to every row,…
-
Help with IF AND formula with cross sheet reference
I am trying to write a cross sheet formula, and I keep getting an #INVALID OPERATION error, and I cannot puzzle it out. My current formula: =IF(AND({Scenario REQ ID} = [REQ ID]@row, {Scenario Status} = "Pass"), 1, 0) If the REQ ID from my scenario sheet matches the REQ ID of this row, AND the Status on the scenario sheet…
-
Recording Most Recent Step in a Process
Let's say I have a three-step process that I perform many times: Draft, Review, Publish. (This is a simplistic version of more complex repeated processes.) For each step I have a checkbox column. For each iteration, I create a new row in SmartSheet. I would like to see the status all current iterations in Card view, so I…
-
Columns Moving Automatically
Has anyone had any issues with column headers moving around the sheet automatically. I have multiple sheets referencing each other using vlookups to report back and also to use tools I have created. Therefore the location of certain columns are highly critical to my companies daily workflows. I have already confirmed that…
-
IF Function With Multiple Drop Down Selections
I am not sure how to "Nest" if functions for my application or if I need to use the "AND / OR" functions with it. Essentially, when my field team updates the [Field Status] column I want the appropriate colored circle to update in the [Risk Status] column. Red = Delayed Gray = Not Started Yellow = In Progress Green =…
-
Managing complex, multi-sheet schedules
We are building a large multi-family project. We set up our schedules to be broken out by building permit shell and units. There are 99 sheets in total built using the standard project template with some customizations. Our plan was to roll up these sheets into reports that would allow a project manager to easily update…
-
Assigning Multiple Resources
I've seen posts going back 3 years that address this subject, and it's little mind blowing that a feature as basic and essential as this does not seem to be possible yet. My team works on multiple projects each day, and each project has at least three different team members assigned to it at once. Without the ability to…
-
Ready Status Formula or Column
Hello, Could you please create a formula or column which lets us that a row is ready to be executed, as the predecessors have all been completed. Best Regards, Kartik Shah
-
7 AM shift start and Lunch time
Currently Smartsheet Project uses a default 8 AM time as the start date for each day in a project schedule. Is there a way to change that to 7 AM? I am stuck in creating a formula for that. Also, is there a way to take out the one hour lunch that is automatically calculated in a schedule?