Discussion List
How to build a consolidated calendar from many other sheets.
Hi I am currently developing departmental marketing calendars with a team for different portfolio's. For example we have events, B2B, B2C, Digital. Each calendar has past and active/upcoming items. My ultimate goal is to get all the data from the calendars and pull it onto a consolidated calendar for the whole department.…
Highlight parent if child task is in the past
Hi I have a sheet that has a column called Task name it has a main task with 4 subtasks (child) below it. The sheet has a Task name, Status and due date column. If the 1st sub task due date is in the past and not marked complete how do I have it highlight the parent of this task Red. If the 1st is complete it is no color…
How to assign points to answers selected thru drop down on form
Hello, I created a form to be used during a training exam. Each cell has a drop with 3 options, Proficient, Needs Improvement, Not covered. Is it possible to assign each option a point value ( 3 - proficient, 2 Needs Improvement, 1 not covered) and have a total calculated once completed? Thank you
Dynamic Filter on Dashboards
I really miss allowing the user to actively filter information from their dashboard view. I wish I could have a filter button that could be positioned on the dashboard. Then the user could choose to see the data of a period or a project, for example.
New Smartsheet Defaulting to French Despite Language Setting Change to English Canada
This discussion was created from comments split from: How can I use Smartsheet in english?.
Auto Generate Defect ID
I am using SmartSheet to complete UAT testing. I need to create a Defect IDs whenever a status is updated to Defect. This Defect ID needs to be a unique number so it can be tracked by partners. If the status is updated from Defect, the Defect ID needs to remain in the column. How would I accomplish this?
Card View Settings is NOT WORKING
I try to change the fields displayed by check/unchecking the boxes, but nothing changes. Cards still look the same... PLEASE HELP
Need help with a cross-sheet reference formula.
I am trying to create a cross-sheet formula so I can count the number of projects for a specific PM where the show start data is in the month of January and year is 2024. The source sheet contains show start dates that are in 2025 so I want to be able to avoid counting them by mistake. I'm basically trying to count the…
How can I reference a sheet summary
I am building a parent sheet to create reports from a number of child sheets. I would like to reference the sheet summary of the child sheets in the parent sheet to use in calculations.
Auto-Archive In Control Center
I think an auto-archive feature in Control Center would be great. It is currently still a manual process where a program lead has to go into Control Center and run the archiving automation. What would be ideal is if we could set it up so that (for example) once the Status on the Summary Sheet is changed to "Ready For…
