Our Construction Company is wanting to have a Smartsheet to keep track of data for our weekly schedules. How do I get our schedule to automatically appear in a Google Calendar? As of right now, nothing is even showing up in our Smartsheet Calendar, so I don't know if it is a problem with the wrong column being made primary…
The outlook integration as it exists is nice if you only have one or two projects. As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format. For example, when i set a task or appointment date in Smartsheet I would like to be able to…
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be able to do so with only one trigger (after the sheet has all of the attachments.) Thanks…
Hello I am creating a website using Wix and I am embedding a smartsheet form into a page that is only accessible if a user is logged in to the website. Is it possible to pull their name and email into the form automatically? TIA
I have an MSP plan that contains financial information. When I import in to Smartsheet it does not import these columns. I have tried exporting to xml then importing but get the same issue. Is there a simple way to import all columns from an MSP file into Smartsheet? Am I missing something?
Recently have been testing out functionality within Smartsheet to compare to other products that are very similar and there seems to be a critical issue with the import functionality from MS Project .mpp files. See below from the same .mpp file: PCH-36 should be a parent on the same level as ASC/OQR, the section is…
Hello - Can someone please enlighten me as to exactly which fields are imported from MS Project into SmartSheet? As far as I can tell, the (non-custom) following fields get automatically imported: -Task Name -% Complete -Duration -Start (to "Start Date') -Finish (to "End Date") -Predecessors -Resource Names (to "Assigned…
我有一个奇怪的问题在使用智能sheet and exporting Reports for the first time. I created a report from one of my sheets, with one column that includes a hyperlink. It's a pretty long link, but the text is wrapped so it simply splits the link up with a line break in the export. However, the actual HYPERLINK that it…
When a Sheet is currently exported to Excel, there is no reference to any attachments that may have resided in the Sheet. As a minimum, it would be good to have a column in the XLSX that displays the name of the attachments included in each row.