Best Of
Re: Visual layout of Automation builder screen
Oh, I love it! Although I personally haven't had any issues with the layout, I know I'm in the minority. Almost everyone I've taught automations on gets tripped up with the logic workflow. The updates you made are minimal, but make a HUGE difference in how things flow with the eye. I think something like this would absolutely help people understand the logic flow better!!
Re: Construction Project schedule
Hi ben1984,
In Smartsheet, the Critical Path only highlights tasks that directly control the project’s finish date. Based on how your schedule is structured, the behavior you’re seeing is typically expected and usually points to how the task logic is set up rather than an issue with the feature itself.
1. Early Tasks Are Not Driving the Project Finish
Even though the schedule begins earlier, the initial tasks likely have float (slack) because:
- They are not fully linked (via predecessors) to the tasks that determine the final completion date, or
- There is a longer parallel path later in the schedule that is ultimately driving the project end date.
Smartsheet will only show the critical path starting at the point where tasks first have zero slack.
2. Missing or Broken Predecessor Links
Often, tasks appear sequential on the Gantt chart but are not actually connected through dependencies. If an early task:
- Has no predecessor, or
- Is linked to a summary row instead of another task row,
it will not be included in the critical path calculation.
3. Summary Rows Do Not Carry the Critical Path
Critical Path is calculated only at the task level. Summary rows are used for rollups and organization, but they do not participate in dependency logic. If early work is grouped under summaries without task-to-task dependencies continuing forward, the critical path will appear to start later.
4. Constraints or Manually Entered Dates
Manually entered start or finish dates, or date constraints, can override dependency logic and introduce float. This can prevent otherwise sequential tasks from being flagged as critical.
Recommended Next Steps
To troubleshoot, I’d suggest:
- Verifying all early tasks are connected with task-to-task predecessors through to the final milestone
- Avoiding dependencies tied to summary rows
- Adding the Slack column to confirm which tasks truly have zero float
- Reviewing and removing unnecessary manual date constraints
Key takeaway: The critical path isn’t missing—it’s starting where Smartsheet determines the schedule actually becomes constrained. Once the dependency chain is fully connected, the critical path should extend back toward the beginning of the project.
Hunter Taylor
Re: Not enough space in the cell for my notes
Using row comments should be fine. They do not auto-delete or anything like that. You can even link them to a column to automatically display the most recent update in a cell for a quick reference.
Paul Newcome
Re: Changing single asset access on new membership model
Hi, @jmhoward With the new Smartsheet membership model, workspace permissions now override individual item permissions. If a user has Viewer access at the workspace level, you can’t give them higher (e.g., Editor) access to just one item within that workspace—item-level upgrades won’t take effect. To give higher access, you need to update the user’s permissions at the workspace level. This is a change from the old model.
amarkumar
Re: Collect Data Based on Today's Date
Why not rotate the data?
Columns are areas in the factory and rows are the dates.
Each area has 3 columns. Plan, Actual and difference. You import the data. Each day you have an automation to ask for an update for the row with that day's date asking for an update on the Actual column and then use a column formula to compare the two.
/marc
Re: Incorrect WeekNumber or(??) Year when trying to return a 'Week Number of Year' calculation
You can use an IF statement to add 1 to the year if the year of the date plus 6 days is greater than the year of the date.
=RIGHT(100 + WEEKNUMBER([W/c date]@row), 2) + " of " + (YEAR([W/c date]@row) + IF(YEAR([W/c date]@row + 6)> YEAR([W/c date]@row), 1, 0))
Paul Newcome
Re: Dropdown values aren't showing in form using the new dropdown link to sheet
The above information is actually incorrect, Linked Dropdowns can be used in Forms, they just can't be set up in Forms. Here's more information:
In fact, we have a new article that specifically goes through how to use a linked dropdown column to make a list that removes items as they're selected!
See:
Is there any possibility a different column has been selected?
Cheers,
Genevieve
Genevieve P.
Re: Table mode
I 100% agree and that is in the same spot I am in. I do use it internally to show our team new feature sets but anything customer facing remains in Grid view for now.
Prime George
Re: Table mode
@Prime George @amarkumar Yep, the lack of feature parity with grid view has prevented me from using Table View in any production solutions for clients. For those not well versed in Smartsheet it's hard to explain when and how to switch back and forth, so we just still live in Grid view :)
Darren Mullen
Re: Report that includes multiple sheets
@Dina B , could you:
- Add a formula column to each sheet with the name "Report order"
- Put the order number as a formula in each sheet.
- Sheet A > "Report order" =1
- Sheet B > "Report order" = 2
- On the report sort by "Report order"
Alternatively, you could add a number to the start of each sheet name and sort by the "Sheet name" field.
Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology
Neil Egsgard
