-
Harvey Balls / Lookup or Max ?
Dear all, I am trying to find a smart way to use formulas to make a large data table more accessible. The situation is as follows: I have a number of companies that are represented by one line in smartsheet. This line included a unique ID as well as names, etc. For each companies I can have 1 or more lines - children -…
-
Jira Connector + Issue Links?
Hello, Curious if there's a way to effectively sync Jira Issue Links. They support several very powerful links that help identify order of operation that would be an extreme pain to replicate in Smartsheet. Has this feature been implemented, and what's the process to connect them correctly?
-
Excel Dashboard Templates
Is there any way to upload an Excel dashboard into Smartsheets so that it is converted to a Smartsheets dashboard? My boss is interested in using the Excel templates but annoyed that there aren't any templates available for Smartsheet dashboards. The beauty of the Smartsheet Dashboards is that external executives can…
-
How to total quantity based on similar name in column
I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the total points column. I have…
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Saving and exporting
I am a new user of Smartsheet with some questions: 1. Can we save the project plan on a local storage device? 2. When sent as Excel, only tasks, dates, and duration of the task are sent. How can we send the complete view showing the days and weeks on which the tasks are marked? 3. Can we work on the file off line? Thx.
-
Is it possible to keep my original sorting order when pasting in Excel data?
When I paste in Excel data Smartsheet automatically sorts by the first column. Is there a way to prevent this?
-
Calendar Schedule
I'm a new smartsheet user. I'm curious if I'm able to make a sheet, that pulls data from 4 columns and puts the info into Calendar View either to be displayed onto google calendar or on smartsheet calendar. Driver Name: Location: Date: Time: Any help appreciated!
-
Resizing an Image
Is there a way to resize an image that has been inserted into a Dashboard? I am able to increase the size of the Image Widget, but the image is still not large enough and does not fill the widget area. Need to know if I can manually resize the image
-
Export to Microsoft Project Aplying Filters
Hi All, I have been trying to set up a report and later on export to Microsoft project, although without too much sucess. The idea is to show only parents rows (project deliverables). The report is for a client which cannot see the full project plan. Smartsheet seems to always export the full project plan even when filters…
