-
Color Coding Calendars - Different Colors for Different Calendars, but from the same sheets?
Hello! I have a workspace with a ton of different sheets that each represent a project timeline for a single client. We are creating different reports to pull together program/client level views for things like team PTO, client due dates, internal resourcing priorities, etc. We use the calendar view of our reports…
-
Using multiple excel sheets, import into the Simple Information template.
Hi, I'm using the SS Simple Information Template where I have to import multiple excel client documents. How do I create multiple reports to display in the dashboard? I'm having the issue when adding a new report to list all the data correctly. Richard
-
Sheet admin can't add or move columns
We have given access to project plan to one of our customers who has a Smartsheet account outside of our email domain. This user has been given admin permissions on the sheet, but cannot add or move columns in the sheet. Is this because their license isn't in our domain, or do they need a paid license to be able to add and…
-
How to create a master calendar from multiple workstreams
Hello - I'm trying to create a master calendar of tasks. I have 4 different workstreams with different due dates and I want all of the due dates/tasks to display in calendar view so I can see which weeks have a heavier workload than others. Is there a way to do that? If so, how would I organize myself? I'm currently…
-
How to combine & link multiple source sheets into one master sheet?
Hello - I have searched & searched and cannot find a solution to my challenge. Here's what I am trying to do. 1) I have multiple product developers working in their own "source" sheets, managing only their products with data points relevant to product development (item#, item description, vendor, cost) 2) Those products…
-
Can Smartsheet create a new project with the completion of a form?
I couldn't find a good answer amongst the posts already in the community but perhaps I wasn't searching in the right fashion. The way that my team has project intake setup is that once a new form is completed, it feeds the form information in to a sheet which is a pretty standard action. What I'm wanting Smartsheet to do…
-
Pulling report data from a folder of sheets
I have several reports that need to pull data from multiple sheets. Those multiple sheets represent current projects. When choosing the sheets from which to pull data, I enter a checkmark for the entire folder, with the understanding that any new sheet I add to that folder will then be included in the reports. But when I…
-
Can You Copy and Paste MULTIPLE Images into Multiple Cells?
We use Autodesk Inventor and when we're designing an assembly, the bill of materials creates thumbnails of the items for each line. We can export this to Excel and it puts a thumbnail image into cells inline with the item information. We would like to be able to add these thumbnails to Smartsheet so it's a quick reference…
-
Different Settings in Same Project Sheet
Is it possible, by formula or settings to have within the same project sheet, some tasks & sub-tasks that will need to use a 7-day work week (no weekends, no holidays) and also some tasks (and sub tasks) that will need to utilize the 5-day work week and holidays? To clarify, all of this is in the same sheet for a single…
-
Workflow For Purchasing Process
When I change the Status from 1)Request For Requisition to 2)Requisition Created, I created a workflow that would send an email to the Requestor. This status change is being done in the Smartsheet table, not via a Form. Below you can see the Workflow. Currently the WF is not triggering. What mistake am I making?