-
Sheet to populate another sheet?
Looking for a way to minimize damage (deletion of rows of data) of a critical - and very large - sheet. Seems there's a 'glitch' that causes this and it's happened twice in the recent past. Things I thought of but don't think will work... "locking rows" doesn't work b/c team needs to edit/update frequently; creating a…
-
How to get realistic timeline of the project considering the resource allocated
Hi all, First time using smartsheet and haven't been able to figure it out. I searched on this forum and seems like back in the days people had similar issues. Not sure if it's been resolved or not. Here is the issue: I have contractors that are helping with the project. I need to get a realistic timeline to know when…
-
Problem with multiple IF statements
I have 2 columns: one is the responsible party for the row and one is a checkbox that needs to be checked depending on the value in the responsible party column. I have this and it works: =IF(HAS([Responsible Party]@row, "Analyst"), 1, 0) But I need to check for 2 values, so I tried this, and it doesn't work:…
-
Headers from Excel to Smartsheet
I need to change 150 old column headers on my Smartsheet to the new ones I have on my Excel sheet. I don't see a 'Header" copy paste function. One at a time would be too slow. Ideas?
-
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.