-
Index / Match Multiple columns from another sheet
I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the team information. When I add a name to the new sheet, I assign that name to a team.…
-
Taking a dashboard "snapshot" as a pdf and attaching to a given row
While the header of my question seems confusing, hopefully an easy solution exists somewhere. I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to a sheet ("sheetX" for later reference). What I want to do is try and capture a part (or…
-
export schedule to XML, the dates got moved
Hi There, When I export schedule from Smartsheet to XML file and open XML file in Microsoft project, the dates of some tasks got moved. Has anybody had the same problems and possible ways to fix it? Dale Dai
-
Worksheet with more than 20 sheets cannot be imported
If Smartsheet only imports the first sheet in a workbook, why does it care how many other sheets there are??
-
Export Dashboards
Hi All, I really need to export my reports and dashboards and the PDF option is too limited. After exporting to PDF and then using a program to convert to PowerPoint or Word, the quality is not the same. We as a company would strongly recommend the option to export reports and dashboards (Word, PowerPoint, etc.) directly…
-
import and consolidate daily changed excel file with SS sheet
Hi, currently my team (4 members) uses one excel file to save information about insurance incidents (task tracking with regularly action documentation f.e. what have craftsmen done, has insurance paid a.s.o). It takes a few month until we all may use SmartSheet. Until that time I would like to daily or weekly import the…
-
Merging two sheets into one.
Does anyone know how to merge two sheets into one seamlessly to include all attachments and discussions please? Thanks in advance, Andy
-
Concatenating multiple Smartsheet fields into a single JIRA field
I have a need where I need 3 different Smartsheet form fields to be concatenated into a single JIRA field. For example I would want these 4 from My Smartsheet fields: * Description of Request * Expected results * Why is this info needed * What resources have you utilized To all be entered into the Description field in…
-
Can't Import Trello into Smartsheet
I get this error every time trying to import Trello into Smarthseet. "An error occurred while importing from Atlassian Trello." Any ideas what is causing this error and how I can get this import to work?
-
Smartsheet + Jira workflow - attachments and multi-select
We are using a smartsheet to populate a jira project. basically, a user fills out the webform, it updates the sheet, and then we push that into jira. The first issue I'm having is attachments. Is there a way to attach the attachment to the new jira story created from the line item in the smartsheet? it doesn't appear as an…
