-
Default properties for rows
I started a new sheet using the 'Template: Client Creative Brief'. I have subsequently changed most things, including the colors. However there seems to be default cell background color (dark blue, see QTY. column in attached screen shot) that shows up every time a create a new column. Does anyone know how this is set and…
-
Equipment Check-out...
Has anyone implemented a sheet for use as an equipment check-out form? That is a web form that is filled out by the user which allows them to select from a database of available equipment and indicate the length of use in days? I think I could do that with a column dropdown list populated with the items that are available.…
-
Smartsheet for Marketing
I am brand new to smartsheet, just trying it out to see if it would meet my needs. I run a marketing unit at a university, and currently use a system called Workfront for our project management and online proofing. Is there anyone out there using smartsheet for marketing? If so, what are the pros/cons you've come across…
-
Embedding a From within Smartsheet
Hi - I've created a form for submission of items in my "email calendar". Our team goes into spreadsheet often, so I don't want them to have to exit to click on URL to submit email request. Is there an easy way to add it into Smarsheet so that they can easily submit a form within our Email workspace?
-
How to make a Status row function like a Status Column
Hello! Is it possible to apply the properties of a column to a row? I want to be able to update the status of each column in a single row. I'm not able to identify where and how to do this; please see my attached screenshot. Currently, I have a column titled Status (circled in the screenshot). I essentially just want this…
-
Email content
Hey guys, Hoping someone can help me out. Im trying to see if there is a template or a way to create a tab that lets you upload email content i.e. a content image plus word doc/text to a certain newsletter and the person who is looking after that newsletter gets a notification when content has been uploaded. Also the…
-
Help with Gantt chart -- only two bars showing
I created a timeline and when I chose Gantt view only two bars on the Gant chart are showing even though I have probably 25 tasks. I have a beginning and end date for all tasks. How do I get the items to show on the Gantt view? Screenshot attached. Many thanks for any help.
-
Sharing Reports
I support a team of graphic designers and I created a report showing them all their projects and tasks. I thought the designers would be able to sort the reports by date, sheet name, % complete, etc, as they need to to organize their workload. But I'm finding out that they are not able to do this even though they have…
-
How to Format Alert/Actions Subject Line in Templates
Hi, I've created a project schedule template that I will use for multiple projects throughout the year (avg. 100). This template has a total of 4 different alerts/actions. The template will default to a subject line like this one for a notification: - "Changes to Schedule #1: Project w/Professional Print2: Notification"…
-
Blocking Actions on a Spreadsheet
We use Smartsheet for our work holiday/vacation planner. We don't want holiday overlaps so I would like to make it impossible for 2 employees to select the same dates. Is there a way to block actions? Is this something that can be done? Thanks in advance!