- Excel template that generates (automatically) formulas for smartsheet
Hi Guys, I made an excel (macro enabled) that allows to my team create projects easily and faster. The file generates (automatically) formulas for smartsheet. I publish the example here You can register time here This is the video The video is in spanish, I will translate it in the coming days. Regards, Álvaro
- Exporting to Excel not working with IE
I am trying to export a sheet to excel using IE and selecting Export to Excel. When clicking on that option it there is no indication of any activity and checking the download folder, there are no files there. Could this be a security setting by the company on IE? Could the file be going somewhere else? Thanks!
- Keyboard Shortcuts (Ctrl+C, Ctrl+V) vs. Right Click Menu Options between Excel and Smartsheet
I've noticed that utilizing keyboard shortcuts (ctrl+c, ctrl+v) provides the needed copy and paste results between Excel and Smartsheet, while using the Right Click mouse method does not. Is there a particular reason for this? Did I miss this instruction somewhere? Thanks.
- How do I export the names/emails of collaborators who have access to a Workspace?
How do I export the names/emails of collaborators who have access to a Workspace? I need to send an MS outlook email to all collaborators of an existing workspace (over 70 ppl). In an effort to save time (e.g. avoid typing names 1:1) & heartache (e.g. inadvertantly leaving off a person), is there a way to export…
- Date format inconsistencies, US/UK
If you copy and paste US-format dates (mm/dd/yy) into a Smartsheet while your personal settings are English (UK) (and presumably other Anglophone options), the data will retain the US format for all dates below 13. Where the date is 13 or more, Smartsheet will automatically transpose the format to dd/mm/yy. This can be…
- Cut and paste rows from Excel without importing an entire sheet
I have created a sheet for registrations and only want to add new registrations from an existing spreadsheet. How do I cut or copy and paste the new rows without importing the entire Excel spreadsheet? I only need to add the new information.
- Importing into a Project Sheet
Hello everyone, As a project manager/trainer, I have been instructing PMs to create projects schedules using the Project Sheet. This is because it includes not only dependencies, but the timeline option. However, if we want to import from MS Project or Excel using the Import function, it imports into a blank template,…
- Unable to import a CSV column as Text/Numeric as automates to Drop Down List
I want to create new sheets from CSV or excel data to create a new Smartsheet chart with a project layout and then create a gantt chart. I can achieve all that but the column for Duration insists on creating a "Drop Down List" type which I have to manualy convert to "Text/Number" before turning on the GANTT chart. This is…
- Printing highlighted changes
你好!我如何打印一张那t has highlighted changes shown? If I send it directly to the printer or export the sheet the highlights disappear. Does it matter if the sheet is "View Only"? Thanks, Peggy
- Multiple Sheets - SUM Dollar Totals in Report
I did a quick search in the community and didn't see this answered exactly, but i think either an Excel export or a future release of Dashboards may provide a quicker/better solution. So here's what I'm trying to solve. I've got 10 sheets that track Paid Claims. When the Claim is paid, a field titled "Date Payment Received…
