-
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!
-
Simple Calendar View for Mailing Schedule
Hey there, I created a grid to show a mailing schedule for affiliate promoting a product launch. I made the primary column for the names of all the affiliates, and then I made date columns to the right for all dates between Sept 5 and Sept 21. Then in the rows for each affiliate name I went across the grid and entered the…
-
Automatic 'Text Wrap' Feature in Grid View
Hello and thank you in advance for your time! One of the sheets that I use prequently has text wrapped automatically in the grid view. This has only started the last couple of days so I imagine someone in the building has changed this by mistake. I have been tasked to change it back. However, I do not know what I'm doing…
-
Auto populate from one sheet into blank rows on another
Hi All! I searched for this, but couldn't find an answer. Maybe it doesn't exist! I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I was TRYING to get them to fill out all information on one sheet to keep things simple for them. Is there a way for me to…
-
Sharing Many Workspaces with Two People
Hi, Attached is a screen shot of my workspaces. Those workspaces that are highlighted I want to share with two people. Is there a way I can send those two people one “sharing email” that will give them access to all these workspaces? Or do I have to send them a separate “sharing email” for each workspace? Please advise.…
-
It does not record what I keep
I am very worried because every time we register something we can not see the changes that we have made in a sheet, if another user enters he does not see what I already record or save. We have a week with this problem and I am also very upset because the smartsheet reliability is lost, Fernando Alonso
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…