I am trying to bring - Stacked bar Chart for the monthly county of the competency. I have generated the data via Smartsheet Report in tis format. However, when I am generating the output report. The report is not rendering as expected. I believe, I can manually build a table with competency values and month and can…
This discussion has been merged.
Happy Friday! Appreciate your feedback, please! Here's a pic from my Project plan (created from the PMO Template) showing the column titles and rows 1-6. Rows 3-6 are in the first phase of the project (under row 2, grey). These are the only completed tasks out of 39 for the entire project. the rest are not started. I'm…
Hello, I'm new to Smartsheet and I want to set up a workflow that records the date and time automatically when a previous column's value is changed to "Yes". I know there's a template for recording a date when specified criteria are met, but I couldn't edit it/find one to automatically record time. I see that there was a…
In our team project trackers, we are leveraging worksheets with grandparent/parent/child relationships to organize by the the different business/clients/projects. Our desired automated reporting output is to transpose most of what is captured in a row format into a column to enable a snapshot view that is horizontal in…
My team is looking to lock a cell so that only admin's and owners can edit the column, but we need our other team members with Editor permissions to be able to at least copy and paste the cell and have the data move with it to a new row. Currently, an Editor cannot copy the cell and paste and have the data show up in the…
Creating Dashboard, Sheet to centralized all links to other sheet in a Workspace. I need non Smartsheet user to easily navigate from sheet to sheet to collect data from them. My tasks: Creating Workspace out of a template. Publish sheet Insert hyperlink to freshly created sheet/Dashboard Share Master sheet to non…
Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would format their sheet to account for this. For example I have a task that needs to be done the Monday following all major holidays…
Hi!! We have a large program & want to change where some of our Profile Data fields are being entered without breaking things / renaming fields / doing a ton of avoidable repairs. I'd love some advice on common issues / the best approach! ------- Program Setup (for reference if needed, feel free to skip to the goal 😊) Our…
Currently Holidays can be configured in 2 locations on Smartsheet. At the administrator portal and at the sheet level. It would be ideal if at the sheet level you could select pull in holidays from your administrative settings. This should be something you can do when creating a new sheet from a template so that you do not…
