-
Add New Template Sheets to Existing Project Workspaces In Bulk Via Control Center
Currently you need to manually add a new "optional" template to each project one by one. This is incredibly time consuming. We need a global update option to add a new template sheet to all existing projects automatically.
-
Download ALL Pages in Template as PNG
We have a need to download ALL pages designed in templates as PNGs. We create customizable art for social media and currently BrandFolder only allows you to download the first page of the template art unless it's a PDF. This renders other pages in the template worthless. We should have the capability to download every…
-
URLs for Templates
I have a few sheets that I saved as templates for other team members to use. I wanted to make the templates accessible from a dashboard by adding a shortcut to take users directly to the template preview so they can view it and choose to use the template.
-
#BLOCKED Error with COUNTIFS when Range columns are populated via equations
Hi, I am trying to calculate the amount of "Used Inventory" by counting the number of times "Block Date" appears between "DATE 1" and "DATE 9" but am getting the #BLOCKED error. Columns "DATE 1" through "DATE 9" are populated by equations based on "CheckIn Date" and "CheckOut Date." Below, you can see the columns in use…
-
Not able to generate Stacked bar Chart using REPORT
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…
-
Merged: Formatting Capabilities in Automation Emails
This discussion has been merged.
-
Project Plan - Start/End Dates, % Complete and Duration columns not updating.
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…
-
Record the time when specified criteria are met
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…
-
Project Status Report > Horizontal View
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…
-
Copying Data from Locked Cell as Editor
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…