-
Data cannot be charted, unable to read source data.
I am using a template from Smartsheet (Project Tracking and Rollup). When I attempt to link the sheet to my chart widget, I get the "unable to display chart" notice. The chart should show percentage complete, but it doesn't. I will add photos of what it should look like, the notice, and the sheet that the chart is pulling…
-
Dashboard sharing specifics.
I use a workspace for all project related documents, reports and dashboards. I share some (not all) files with my customers. I know I can share individual documents with a particular list of people. My question is specific to dashboards. When I share the dashboard, it seems that this can only be done by sharing the entire…
-
Logo image on sheet header is blurry
Hi there, I've added a logo onto a sheet header, but when I export this is showing as blurry. I've tried various sizes but this is still showing up blurry. I also seem unable to adjust the overall size of the logo on the sheet as this is currently showing up quite large.
-
Uploaded images on sheet are showing blurry
Hi there, I've created a sheet and have been uploading images from my phone via the app. All images look very sharp on the phone even when zoomed in. However, when I open the same sheet on my desktop all the images appear blurry and they export blurry too. I can't seem to locate any settings to adjust this. I've tried…
-
Automation Email, delete the link to the smartsheet worksheet
Dear Smartsheet community I hope that you might be able to assist, I have created some work flows that alert people about changes to items that they have submitted. When I test the automation, the email that is sent has a link to the smartsheet. I would like to not include this link in the email that smartsheet generates.…
-
Edit Saved Workflow not working
I am trying to edit an existing workflow, but when I go into Manage Workflows, and try to edit or duplicate a saved workflow nothing happens. I do not get any kind of error message, it just literally does nothing when I select either Edit or Dulplicate the workflow.…
-
Is there a way to reference a summary field from one sheet in another sheet?
I have sheet that contains master data for customers. The master data customer sheet has a set number of support hours available for each customer. I have another sheet that is collecting support hour information for the customers. A summary field has been created for each customer that sums the support hours for that…
-
Countifs Cross sheet reference
I found this similar issue and used the answer to fix my problem, but it didn't work for me. =COUNTIFS({Sheet - Contract Management - Complete Lib Range 3}, "Executed", {Sheet - Contract Management - Complete Lib Range 4}, "A&E") However, I am getting a 0 return which I know is not correct. The column that has the program…
-
Move Row: Will not move if condition has a dropdown list
Hello, I am trying to automate copying a row from master sheet to child sheet. The trigger is when a row is changed to "New" it should copy to the child sheet. This is one of 4 choices in the column. It is a column with dropdowns. When creating the automation, I am not able to choose "new" as the thing it changes to in…
-
Looking for ideas on adding "help text" to ensure consistent input of data into cells
Is there a way to add help text to a column header? We have multiple people entering data on the same Smartsheet and there are inconsistencies in the way the data is entered. For example, sometimes dates are entered 12/14/22 or 12.14.22 or 12-14-22. I am looking for a way or a place to put "best practices" or "help text"…
