-
help with auto numbering my projects that have children and grandchildren
I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as I'd like the task to read 40.c.1, or something similar that…
-
Using AI and Voice to Simplify Task Updates in Smartsheet
Hi everyone, I wanted to discuss how AI-driven input methods, especially voice, could simplify everyday tasks and update workflows in Smartsheet. In many project environments, updates, action items, or follow-ups arise during meetings, calls, or brief discussions. These are often added to Smartsheet later, which can lead…
-
Smartsheet form with built-in AI
You could have a form with built-in AI. Eg: we have a form that becomes a row in our matrix tracker Smartsheet. For example: Marketing Manager Geraldo works with AI, so the form will start asking his name/email. Based on that, the form will make suggestions(what kind of Asset: Brochure, Flyer..) , category(AI for industry,…
-
Merged: elapsed days as a predecessor lag
This discussion has been merged.
-
Need to add total track the amount of times a person signed out equipment in 365 period from today
Here's the formula I'm using put it's coming back unparseable =COUNTIFS(Name:Name,"Yes", [Date signed out - OVERALL]:[Date signed out - OVERALL], AND(@cell >=TODAY(-365), @cell ,=TODAY(365) Appreciate any help.
-
Construction Project schedule
I have created a construction project schedule and am unable to determine why the critical path is not displaying from the start of the project. The file is attached for reference. If anyone is familiar with this issue, please advise. https://us.v-cdn.net/6031209/uploads/XHXHC4EHD5NN/project-schedule-12-19-2025.pdf
-
Automated Dashboard Snapshots & History
Problem: Current Limitations Ephemeral Data: Dashboards are "always live." As soon as the underlying data changes, the previous state of the dashboard is lost forever; there is no native way to view "what the dashboard looked like last Friday." Manual Workarounds: Users must manually use snipping tools or "Print to PDF"…
-
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
-
Displaying multiple time periods in Gantt view
Is there a way to display multiple time periods in Gantt view? Example: you have staff members that are your primary people, and they are contracted for 4 months, and then secondary or "fill" staff members that sit in when the primary is away on sabbatical or similar break. Idea here is that the gantt bar on a given row…
-
Prevent Sorting on Shared Sheet
We have a lot of users using Smartsheet as a tracker. Team members sort and then filter to get the information they need. The problem is that the sort affects all of the other users who are sorting on different things. Is there a way to have the sort only apply to the user that is sorting? Similar to the way that filters…