-
Look Up Attachment from a source sheet to another Sheet Using Datamesh, Formulas etc.
Hi Smartsheet Experts, I have attachments that I want to lookup or transfer from a source sheet to another sheet. I have tried to do it in the Datamesh but I can't find the attachment as a column. Is there a work around or Smartsheet Apps/Addons that can help me to that? Can I also use third party app like zapier and like?…
-
Web Content Widget rejecting iframe
Using the Web Content Widget, we are trying to embed a video player using a valid iframe tag but received an error saying: "We couldn't find any embeddable content from this link. Please check the link and try again." I tried testing the iframe on a regular web page and everything is working as expected. Are there any…
-
Free Data Shuttle Webinar - March 16
Hello! We will be hosting a free webinar on March 16th "Intro to Data Shuttle." Join us here to learn how to automatically and seamlessly upload, or offload, data between Smartsheet and other tools.
-
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",…
