Automating updates from shared Excel doc to a Smartsheet doc
Is there a way to automate updates from a shared Excel file to a Smartsheet doc? I am currently manually entering data from an Excel file into a Smartsheet to update the information on a Sight. It would be great if the data was automatically updated in the Smartsheet when the shared Excel file is updated. Is that possible?…
Update existing smartsheet by excel
Hi, I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. However, cs manager always change. We have 1000 buildings. Admin will send update list every week.. I know there is data live connector.. if I change info in…
Import multiple excel sheets into one Smartsheet
Does anyone know how or if you can import multiple excel sheets into one smartsheet?
Notification/Reminder for Past Due Task
I have reviewed the many questions asked previously by others regarding Notifications and Reminders as relating to dates and I am either not understanding them or they are different enough from my application that I don't feel the solution is applicable. I am simply attempting to send an e-mail to an individual whenever a…
Tag Multiple Contacts to one row?
At my work we have a project in a row and assign it to one employee, but we also need to, for lack of a better word, tag other employees who need to be able to quickly see the progress being made and oversee the project. Ideally it would be great to have card view show each employee with their assignments in one color, and…
SmartSheet and OneNote - Where is Integration?
I see posts going back to 2015 and older promising OneNote integration. If you're not going to do it - just say so. SmartSheet is a fine product, but without ON integration, it creates too much effort to keep both platforms current. OneNote is fantastic at the details of PM, but does not handle the organizational aspects…
Sheets vs Workspace
New User: Confused do I setup Sheets or Workspaces. 7 companies, coworkers share documents and scheduled tasks. Do we set up both?
Feature Request: We need advanced functions to connect and control multiple sheets
I am a project manager at a construction company so we use Smartsheets pretty heavily for everything from vehicle mileage reporting to project forecasting. The single biggest improvement that I would like to be done for Smartsheets is for greater links between multiple sheets. We are thinking about migrating to Sage 100, a…
[SmartSheet-Jira] Few basic workflow queries
Hey Guys, I started to use the JIRA connector for Smartsheet and run into some basic issues while creating the workflow. Idea here is I want to create the Jira tickets (Epic, Story, Sub-tasks, Bugs) from Smartsheet but need 2-way sync to keep updated everything on both the places. Query 1: during the workflow setup, I…
Report-level access to sheets
Hi, So, there are plenty of ways to view the data in a sheet, and to regulate access. My issue is when a sheet contains sensitive data, and that you want to give view and update access to only a few of the columns via a report. A good example is a column for internal comments and one for external/customer comments. Since…