-
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.
-
VLOOKUP data type question
I'm using this vlookup formula to pull back a value from a data sheet. Let's say the value of NUMBER81 is 123456 and when I type in the formula on the desire sheet it returns "No match". When I go to the ACCOUNTS sheet and look at the data there is a value equal to 123456 in Range 1. When I put an apostrophe in front of…
-
My Smartsheet is showing a row number skipped
I have a sheet that goes from 213 to 215... ideas?
-
Report assigning random background color
I have a report that pulls in data and then, for some reason, applies a yellow background color that is not found in the original sheets. I found a 2016 discussion with a similar problem. The Smartsheet rep said it could be old data, so they refreshed the db? Is that the same case here? Thanks in advance BK
-
Quote Request to Multiple Suppliers
Hello, I am looking at finding a way to send a quote request to a chosen list of suppliers. Is there any way I can send a row with all of the quote information to multiple email addresses where it will create a new row for each quote returned? I can then review the prices before choosing which supplier to proceed with. Any…
-
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"…
-
publish workspace structure without complete workspace
I have a number of sheets and folders in a workspace. I have the workspace shared with some people and they can see my structure fine. For other users I have only shared specific sheets, these other users don't actually see the structure I created at all, with their account they just see another sheet in their general…
-
Consolidating several smart sheets in one (appending columns)
Hi. I have several smart sheets with 2 columns, being the first column common to all. What is required is to have an aggregated smartsheet with the common first column and append the second columns of the other smart sheets. I.E Smarthsheet 1 Subject Juan math A physics B Smartsheet 2 Subject Peter math A- physics C…
-
IFRAME - load with Fullscreen option
I'm embedding several reports / dashboards into a sharepoint instance and I would like to have them load in full screen by default. I am referring to the Normal View Vs the Full Screen View that can be achived by clicking the appropriate icon on the bottom left of the embedded frame. Please help! Thanks