-
How can I generate a project planned vs. actual S curve in smartsheet?
I have a project plan with task name and timelines. I am using the gannt chart template. I want to see an S curve: Planned vs. Actual. Wondering if there is an automated way to generate that?
-
Creating and Saving Template Sets
Hey Is there a way that I can save a folder, that I created, containing sub-folders, which contain sheets, reports and dashboards as a template set?
-
how to relate smartsheet issues with other smartsheet issues
Hi there, I have created a Smartsheet support ticketing system and use Dynamic view also. Is there a way to relate smartsheet issues with other smartsheet issues when a new issue is raised so that a user reporting issues does not fill everything in a form from scratch, you can associate the issue to a previous one? Thanks…
-
Is it possible to pre-populate a form based on the data gathered in another form?
Here is our use case. It is a three step process. In the first step, the learners will submit some information. In the second step, SME analyzes the submissions and add (fill-in) more details (multiple columns). And then, after 45 days, the learners goes back to the form (which has SME comments, details) and add (fill-in),…
-
Trouble exporting gantt chart
I am trying to export a program with Gantt chart to PDF, however when I export it, the program schedule with dates etc. is there on the left but on the right where the gantt chart should be, there are nothing but empty lines and columns. I have printed these charts hundreds of times before without any problem but now…
-
Row level information updates.
Is it possible to create a row level form, if not is it possible to make an update request link for a specific row that remains open and does not just disable after one use? I want my client to be able to use the link to freely update and change row info without giving them access to the sheet directly.
-
Importing Excel Data into a template
I have created a template with all of the appropriate columns, workflows and filters that I need. I have a 4900 row Excel spreadsheet with my data. I would like to import the Excel spreadsheet into my template. I can copy and paste, but since the limit is 500 rows at a time, it takes time. I cannot seem to find a way to…
-
IOS SmartSheet APP , Search tool within PDF
Is there a work around to access the search tool for PDF attachments on tablets? I noticed that there was no option to search an attached PDF file for a specific text/number.
-
Grouping in Reports - subgroup filter?
Hi, I wonder if someone can help! i am having trouble in grouping a high level report in line with our organisational structure. Our Structure is as follows:- Organisation, Delivery Board, Programme, Project. We cover multiple organisations so we want to be able to drill down (using grouping) from the very highest level…
-
Row Properties
I've read through a lot of semi-related answers here, but I'm hoping I missed something. Is it really not possible to set different properties by individual cell? All rows within a column must all have the same properties? Meaning, if I want Row 2 to be dropdown, but row 3 to be a numeric formula, that's impossible? This…