-
Contact List Column - Export Emails
Is there a way to export the Contact list names and emails?
-
Deleting a Report Item also deletes it in the Sheet?
I came across an interesting interaction today while editing a report. When I went to delete an item off of the report, the item itself also disappeared from the sheet that it was associated with. Is there any way I can retrieve that information and have it back on the sheet but not the report?
-
Publishing Gantt Chart
We have a Gantt Chart, we have many columns for various items and the standard Start/Finish/%Complete....... We don't want to share the sheet with a lot of people they don't need all those extra columns, we really just want to show them the Primary/Task Column and the the Gantt Timeline that is it. Is there a way to…
-
FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…
-
Restrict input to only values of drop-down list
I have a sheet with a column that I've defined as a Dropdown List with a set of values. However, it seems like Smartsheet still allows other values to be manually typed into the cell. Is there any way to restrict input to only those values defined in the drop-down list?
-
May Feature Release
Our new release includes features to help you define what kinds of information can be inserted in your sheets. Let’s take a look at these new features: Data Validation: Allow Only Specific Values in a Column Use this feature, for example, to prevent collaborators from entering free text in a Dropdown column and make sure…
-
Max number of entries in drop down list?
Hi; Is there a limit to the number of entries in a drop down list? Would a list of 1200-1500 names have an impact on performance? We don't need validation or conditional formatting (e.g. red for a value is entered that is not in the list). Are there best practices for a task like this? Thanks in advance, Andrew
-
create form from text file or spreadsheet
Full disclosure, I just initiated a trial of Smartsheets and haven't yet taken the time to learn its features; this might be as easy as copy paste. Is there a way to create a form from a text file or spreadsheet list? I have a long list of items I want to track during user tests, and thought a form might be a good way to…
-
"Pretty" PDF export -- Google merge, something else?
Hi all, We’re hoping to be able to export a fairly complicated styled PDF from Smartsheets. Imagine a sheet of movie reviews, where Column A is movie title, B is review, C is reviewer and D is date. Each movie can have multiple rows depending on how many reviews it’s received. We’d like to get a PDF that would look a…
-
Duration Column Doesn't SUM up Correctly
Hello, I am using smartsheet for my master project plan and I repeatedly run into one issue, my project Duration count roll up is inaccurate. I have attached a screenshot to provide a better understanding of the issue.