-
Filters for Smartsheet Documents
Hi all, I am looking to add filters for Smartsheet documents. I am relatively new with Smartsheet and have been tasked with creating some documents and reports. We are attempting to model one of our documents after the picture attached (the first one). Here is a synopsis of several goals we are working on: 1.) One of our…
-
Calendar App multiple sheets
In the key features for Calendar App, it says "Create a Master Calendar - Combine multiple sheets into one master calendar." I can't figure out how to pull from multiple sheets. I currently have 1 sheet that has all our projects with a date range, and then I have a second sheet where holidays, vacation, etc. are entered. I…
-
Export row data to Powerpoint or Google Slides
Hey Team, I'm hoping there's a way that I can export row data to a slide presentation (pptx or Slides) similar to the way I can export row data to Google Docs. Anyone have any suggestions? Ideally each row would export to a different slide, and each slide would be in one presentation, but I'd be happy if each slide was…
-
SharePoint 2010 IFrame Help
I have a SharePoint 2010 page that I am using a Content Editor WebPart with the IFrame code embeded in it. I can get the IFRame code for the SmartSheet to work outside of the SharePoint page, but on the SharePoint page it gives me a big blue box. Has anyone else had this issue? Thanks! Andrea
-
DataMesh & Gantt Charts
I am working on a project that we are trying to DataMesh two individual Gantt schedules into one new worksheet together. I've not DataMeshed too much, but is this possible? I use a formula of "Row # + Site #" as my unique identifier for the config. I set up the config, and the first time I kept on getting errors, so I…
-
Pivot App - Transfer of Ownership
I was wondering what would cause the, "Error! Target user doesn't have sufficient sheet/report access.", error when trying to Transfer Ownership of a Pivot Sheet, from one License to another? I own both Licenses, and they are also Business Licenses. I have previously made 20 or so transfers, but I am having trouble with…
-
Data Uploader Filtering
Hi All, Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just wondering what would the correct formula criteria be. Incoming equals TODAY()-30 - or something similar? Screenshot attached.…
-
SFDC Connector - Snapshot Then Track
I know... the title sounds weird. I'll try to explain. I have a Workflow set up with the SFDC Connector. It's currently tracking all opportunities entered by the sales reps within a specified period of time that are staged as [OPEN]. My challenge is that I'm developing a project management process that relies on seeing the…
-
SMARTSHEET MERGE, HIDE SPECIFIC COLUMNS
I built a Fund Allocation Request form that makes people produce PDF for printing at the end of the process. To be able to produce the PDF, I use Smartsheet Merge. But I ran into an issue of confidentiality. Since the form is a finance thing, we don't want the users to see how much funds are requested for each items. Yet…
-
Resourcing is looking at SCC template gantts
Firstly, yes - I know the Control Center sheets are not "templates" but I would want resourcing to be able to filter out the workspace or at least the folder used to spin up SCC projects. Since I pre-load "assembly time" by assigning it to the genaric "Assembly" contact in ALL of the grouped gantt schedule options (of…
