-
How to Add Guests to a Workspace?
I have recently upgraded my subscription to a Business plan, which gives allowance for unlimited Guests. However the team that I already have added to the sheet are limited to Viewer access only and I am not seeing an option to change their designation. How do I make someone a guest?
-
Add additional items to existing formula
I wish to ADD the following to my existing formula: [Reporting Period]@row="Jan", "Jan" [Reporting Period]@row="Mar", "Mar" [Reporting Period]@row="May", "May" [Reporting Period]@row="Jul", "Jul" [Reporting Period]@row="Sep", "Sep" [Reporting Period]@row="Nov", "Nov" Here is my current formula: =IF(CONTAINS("-",…
-
Importing from Excel to Show Changes from Prior Import
I have an Excel spreadsheet that I need to import into Smartsheet. The Excel sheet is generated every couple weeks, which means some of the data may change from version to version. Once I create the initial Smartsheet sheet, is there a way to only re-import the data that's changed, or do I need to create a new Smartsheet…
-
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…
-
How to link a value from Summary Sheet back to Intake Sheet
If I need the value from a Summary Sheet, to link it to the Intake sheet, is this how it should look like at the control center?
-
Sharing/UNSHARING a SHEET
What has happening to the Share a sheet option - I only have share a Workspace - and it doesn't offer the option to share a sheet - and i cant find where to unshare a sheet either - currently to share a sheet we have to send a link and get the user to request access to the sheet - but there doesnt appear to be away to…
-
Cannot turn off "Send as Attachment" in a sheet
My manager set up a weekly smartsheets attachment of a sheet to be emailed to them every week. She now wants to turn this off but when her and I go into the Send as Attachment section of the page it only shows that two were sent instead of weekly for the last year or two and there is no way to turn anything off. How do I…
-
Importing Excel into existing sheet
i saw a post 12/9/19 about importing data, but wanted to see if mine can be done. excell file the is about 100 columns wide, 600-800 rows. Right now i am copying 50 columns, 500 rows at a time, till all are imported. if i import a new sheet, it creats a now sheet. I tried to do a formula pulling in the data, but, when i…
-
Import Excel Data into Existing Sheet
How can a large amount of excel data be added to an existing sheet? Copy and pasting is difficult because there are over 100 columns and over 12000 rows
-
İmported data to existing smartsheet and adding new rows
Hello there, I have been searching for a solution however so far could not found a working answer. I have two files which have same, identical columns. Call them X and Y files, these are imported excel files to the smartsheets. X have 50 columns, Y have same 50 columns and 2 more columns which have formulations. X will…
