-
Rich Text Format in Sheet Cells
We have been converting all our projects to Smartsheet and now have about 86 projects loaded. A big issue for us is, (I would like to know how many other people would want this) we have a column in our status reports that go to our VP's called "Status Comments". The VP's are used to seeing comments with bullet points,…
-
Published report doesn't display for others
Hi, I have shared a report with the publish option, available to anyone with the link. Despite that other people only see a blank page. They should have records listed: Why can this be? I thought the point of the publish option was to be able to share it with anyone but even those with smartsheet access can't see it. Any…
-
How to show a chart (stacked?) of count of each task status + number of late tasks per status
Hello, I have a typical project schedule sheet with tasks, start/finish dates, etc, and have a Status column with several different levels of task status, which includes several status levels (process steps) in between "not started" and "complete". I also have a check box column marking when a task is late (start and…
-
Sorting date via the Grouped-by parameter
In the Report associated with our Dashboard, Smartsheet doesn't seem to allow us to sort by the 'Request Status' columns (which is a Drop-Down menu on the Form and Sheet). Is there a Work-Around? We want these displayed in a particular order based on which step the order is in, based on the Request Status. Thanks for any…
-
Is anyone using Smartsheet for Qualtrics Voice of Customer report dashboards?
we demoed Tableau and some others but already have a smartsheet license and would like to try it in here. If you have, I would love to see, and learn how you are using it to report our survey results. TIA
-
Automate Export to Excel
I am looking at ways I can automate export a smartsheet to excel at regular frequencies. I tried using MS Flow, but the Smartsheet connector doesn't have an option to get to get the content. Any ideas?
-
Dynamic Dashboard Calculator/Model
Hello, I'm still learning Smartsheets and wondering if there's a way to create a dynamic "calculator" type dashboard fused with a form. I am hoping folks can fill out a form live and once submit automatically see the produced outcome, based on the form inputs, on the screen. Is that a possibility? Or is the only option to…
-
Grant Management in Smartsheets
Hello Community, I am setting up a company's grants management system from scratch. I would like to know how others in the Smartsheet grant community have utilized the software to manage grant finances (budget drawdown, etc.) I don't see much in smartsheets on how to use it for grant purposes. Thanks, Shamika
-
Count If Current Week
Hi Everyone, I have some daily data with dates and I want to get the week to date numbers off that data (Monday - Sunday of current week). I know countif is needed but I'm not sure how to go thru the rest. Your help is appreciated.
-
Contact pictures in reports
Is there a way to show the small pictures besides contact names in a "contact list" column type on a report? The small pictures do show up in the grid driving the report, but don't show on the report itself (...and obviously, don't show in dashboards using that report either).