-
Importing Excel Data into a template
I have created a template with all of the appropriate columns, workflows and filters that I need. I have a 4900 row Excel spreadsheet with my data. I would like to import the Excel spreadsheet into my template. I can copy and paste, but since the limit is 500 rows at a time, it takes time. I cannot seem to find a way to…
-
IOS SmartSheet APP , Search tool within PDF
Is there a work around to access the search tool for PDF attachments on tablets? I noticed that there was no option to search an attached PDF file for a specific text/number.
-
Grouping in Reports - subgroup filter?
Hi, I wonder if someone can help! i am having trouble in grouping a high level report in line with our organisational structure. Our Structure is as follows:- Organisation, Delivery Board, Programme, Project. We cover multiple organisations so we want to be able to drill down (using grouping) from the very highest level…
-
Row Properties
I've read through a lot of semi-related answers here, but I'm hoping I missed something. Is it really not possible to set different properties by individual cell? All rows within a column must all have the same properties? Meaning, if I want Row 2 to be dropdown, but row 3 to be a numeric formula, that's impossible? This…
-
What are errors 443 and 502 related to?
Hi guys! Our team received some error notifications on our shared spreadsheet, and they were described as Error 443 & 502. We checked the status for Smartsheet server and no notifications were made today. Is there anyone else with the same problem? Thanks!
-
Restricting access to saved documents within a worksheet
Hello, Is there a way (sorry if this is obvious) to restrict who can see documents saved in a task plan? I believe I can restrict based on an access level (Viewer, admin, User, etc..) But can I restrict more granularly? From an info security perspective, I am being asked to restrict who can view certain docs saved to a…
-
Automation for new row inserted
I have a secondary spreadsheet that is cell linked to my main spreadsheet. All changes to the main spreadsheet are reflected on my secondary spreadsheet except for when a new row is inserted. For example, Rows 1-4 are linked but a user inserted a new row in between 1-4 that is not linked to the secondary spreadsheet. Is…
-
Edit link to a widget on dashboard
Hello everyone, I've cloned (copy/pasted) some widgets on my Dashboard but I'm unable to edit the data source for each widget. This is my method: - can anyone notice what I'm missing? Hover over the widget and click the 3 dots on the top right Select edit and a new pain opens on the right Under "data source" click the link…
-
Approval Workflow with Attachment in Response
I'd like to design an approval workflow wherein I need to automatically attach the same PDF file in all of my Approved Response email. Would that be possible? or my only option is to include a download link from Onedrive or Googledrive in the response so the recipients can get the PDF file?
-
Help! Lost Dates/Predecessors When Moving Rows to Another Sheet
Hello! I have almost 300 rows I just moved from one sheet to another (all columns the same) and when the data was uploaded to the new sheet, all the date and predecessor information was left blank. How do I undo this move to get all my dates back? I'm freaking out! *Edit- I did fill out a support ticket, but I don't know…
