-
Issue with Smartsheet Cell Limit - Data Shuttle
I'm trying to use Data Shuttle to import data into a Sheet upon attachment of an Excel workbook to the same sheet. When I attempt to run this Data Shuttle, I am getting an error that I have exceeded the 500,000 cell limit. The parameters of my source Excel sheet are as follows: Cells: 401,668 Columns: 40 Rows: 10,280 I…
-
Automatically linking different sheets to a master sheet?
Hi, I am trying to create a master sheet with information I need that pulls specific cell data from multiple different project sheets. I know I can use vlookup's and reference another sheet within them but I'm wondering if there is any way to create a template or workflow so that when a new project is added to the projects…
-
Including CONTACTS in the Excel import
I have a list of records that I need users to review and update, but they only need to see the records assigned to their user account. But as soon as I import the file into Smartsheet, the column of usernames (contacts) is listed as text, not as CONTACTS (Smartsheet users). How can I fix this? I want to use the usernames…
-
Import Date column to google doc with my formate
I added Smartsheet add-on/plugin to Google Doc . The DEFAULT column formate in smartsheet is the formate imported to google doc ( ex 23/07/22) even if i change date formate in smartsheet to other formates of my preference stilll the default formate is imported :( Is there a way to import my preferrable date formate…
-
Workflow from Harvest
Hi, I have time logs being imported from Harvest from multiple projects, I then want to split this data again using workflows into separate sheets with relation to a specific project. Eventually I want to roll this out between a team of people (around 10 people). Is this possible as I have other workflows that work fine,…
-
Is it possible to have data automatically inserted from an image by image recognition?
I see that Microsoft excel has the ability to use OCR to insert data from an image so I was wondering if it was somehow possible to integrate a working version of this into a Smartsheet. Thanks in advance.
-
Export to Excel loses hyperlinks
I've read a lot about how hyperlinks hidden behind texts will not export to Excel from Smartsheet. Are there any workarounds for this? I have a report that collates 170 schedules, and the Sheet Name column contains a link to each respective sheet, which is great, if I remain within Smartsheet. However, we are using Power…
-
Import Excel file and include embedded images
Hi, I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something? Or do I have to re-import those images manually, one-by-one? Thanks in advance.
-
3 Month Compliance Tracking
Hello SS Community! I've read lots of answers over time but never asked my own question so here goes nothing! I need to create a tracker for individual employee Compliance for training. We have many tests that each employee performs, but they must stay compliant within 3 months. They can't go 3 months without doing one…
-
Report with image of attachments
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to create a report that can show the picture next to the fields associated the punch list item. Another way would be to export…
