-
Report adding and removing sheets
I have a report that consists of 27 sheets. Shared sheets and report with 3 people. These 3 people do not have the ability to add or remove sheets in this report. Is that normal? I would like for them to remove sheets as they complete a project. Attaching an image - the selection option is grayed out for them.
-
Critical path not showing in Gantt nor list view though dependencies are enabled
i have dependencies enabled in my project, all start/end/durations populated, and critical path button selected, but critical path is not showing in gantt view nor list view with critical path filter
-
Smartsheet equivalent to a popup window or pivot table?
Is there anything like a pivot table in the smartsheet ecosystem? I am looking for a solution that is somewhat like a sheet reference, but perhaps saves the time of double entry? Case in point: those of you that use Concur travel or something similar, how do you organize the data and make it retrievable but also something…
-
Can't find or add a user
Hi, for some reason user rhea.tarin@weststarbank.com is not on the user roles and reports or seat types and true-up lists. We tried to add her using both of her emails and it looks like she was an existing user, and we cannot add her back or find her. Would you please guide us on a solution. Thanks,
-
Are there resources that can support with making custom dashboards?
I work in real estate and I want to build a custom dashboard/template to track where we are at with deals. The pre-made templates are all too specific and hard to use. I've created my own sheet/intake form but am looking for support on building the dashboard and how information is shown.
-
Flagging Tasks as 'Blocked' if Predecessors are past due
Hi everyone! New to Smartsheet and trying to build some features for my company. I've been doing a lot of reading and tutorials, and I think I'm close to the end of this problem. Like the title says, if a task goes past its due date, I would all of its dependents tasks to flip to 'Blocked' status. I made it so far as to…
-
Merged: Gnatt will Have mUltiple Start and End Date
This discussion has been merged.
-
Best Practice - How to introduce a new dashboard that will replace existing dashboards across multiple projects
History: Our PM's have redesigned a dashboard (status report) that replaces our current dashboard format used across all our projects. Problem: I need to figure out how to replace our current dashboard (and supporting Sheet) with minimal effort. We have a Template Library (Control Center users) so both the sheet &…
-
Tired of messy image attachments in Smartsheet?
Tired of messy image attachments in Smartsheet? I built a small tool that lets you upload images directly into **cells (not as row attachments)** — making sheets much more structured and easier to review. 🔹 Before: Multiple attachments per row → hard to track 🔹 After: Images mapped to specific columns (clean & organized)…
-
Skip WBS vs. Deleting Task
Is it best to Skip WBS or actually delete the task? Are there benefits to either?
-
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.
-
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…
-
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…
-
Viewing Last Updated in Sheet
Hello! Is there a way for me to track user interactions in sheets? I have found how to see last updated by. But am I able to get more specific with this? See when a sheet was last viewed? And when updated am I able to track what was changed at a cell level? Thanks!
-
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,…
-
Merged: Workback Schedule
This discussion has been merged.
-
Merged: SHARE A FOLDER WITHIN A WORKSPACE
This discussion has been merged.
-
Counting number of items from a specific month with multiple criteria
I'm trying to count the number of items that were published for each LOB in our operation during each month. I've tried a dozen different formulas, but I can't seem to get any to work. I currently have a sheet summary with the following: =COUNTIFS([Received Month]:[Received Month], IFERROR(MONTH(@cell ), 0) = 1, (LOB,…
-
Can I create dashboards across workspaces
Am I able to create a dashboard, aggregating projects across multiple workspaces? My team is currently building a dashboard, but our projects aren't on the same workspaces, and don't have the same user permissions for all.