-
Roll-up report with dynamic view?
I have a situation in which I’m going to have a team of people, each assigned a group of sheets/projects, and more sheets/projects will be added regularly. I need to be able to: a. Aggregate data from each person’s sheets so they and their managers can monitor progress; and b. Give the team a user-friendly way to keep the…
-
Rows sync with Calendar
Can you prevent specific rows from syncing up with Google Calendar? Thanks I know all rows automatically sync to Google Calendar but I want to prevent certain rows maybe even parent rows from syncing up. Or is the only way to do this is to either delete it from the calendar directly and/or just not include dates to avoid…
-
Pull hours worked (from Resource Management) to column in a Project Plan (in SmartSheet)?
Brand new user here, so I am climbing the learning curve. I just created a simple test project in Resource Management. I also created a Smartsheet project plan (i.e., a grid) that matches the Resource Management project. Resource Management is enabled. For now the project plan includes columns showing the amount of time…
-
Sub different projects & Sync information possible?
Is it possible for smart sheet to allow to manage multiple sub projects within a master project? Each of these sub projects will be updating the tasks and data separately but it should allow to get synced on to this master project whenever change happens and visible to all. Are there any restrictions?
-
CDATA import into Smartsheet cause apostrophe problem
We are using an external tool from CDATA to import data into Smartsheet from MS SSIS. We have recently run into an issue where the data load inserts an apostrophe in front of the string value we are loading. We've checked the outbound flow from SSIS and the apostrophe is definitely not there, so Smartsheet is doing this.…
-
Trigger Outlook Calendar Event from Form Submission
I've created a form for my team to use to submit vacation requests with a manager approval and user alert workflow. I want to be able to have an Outlook calendar event added once the vacation request is approved by a manager. Any thoughts on how to achieve this?
-
Python API Library Started Throwing Error
Hi all, I've been using the Python API to update a sheet on a nightly basis. It's been working fine until a couple days ago (not sure exactly when). Now when I call smartsheet.Sheets.delete_rows(sheet_id, list_of_row_ids), I get the following json response: {"response": {"statusCode": 400, "reason": "Bad Request",…
-
Google Sheets integration - automatically updating cells in GSheet when SS is updated?
Hello! I'm looking for a way to automatically update cells in Google sheets, when a cell in Smartsheet is updated. For example, if a Date changes in Smartsheet, Cell C4 in google sheets would update to the new date. Is this doable? Thank you!
-
Using Smartsheet Merge Add-on for Google Docs Problem
Hi All, I dowloaded the add- on of Google Docs with smarsheet, and I was able to connect it successfully to my relevant sheet in smartsheet, When I tried to add the relevant data to each row in my table, from each row in my smartsheet sheet it created a new table in a new page. Is there a way to embed the data from each…
-
Timeline Variance indicators
Hi, I am new to using Smartsheet and was wanted to confirm a few things timelines related: Can Smartsheet create predecessor and successor dependencies (FF, FS, SS, SF) similar to MS Project? Does Smartsheet allow for WBS elements to be created through indent / outdent similar to MS Project? Can Smartsheet allow linking to…
