-
Developing Library check-out list
Hi! I am looking for suggestions/help on a formula for a library check out sheet. In columns I haveL check out date / Number of Copies / Copies Available. I am struggling to figure out an automated process to get the copies available to update once when the number of copies is changed. When the form is submitted it says…
-
Pack Copy / Design Brief
My company produces items that hold multiple components within point of purchase packaging, and therefore we need to use a very detailed pack copy template to our design team (including ingredients/ nutritional data for 3-4 products). While we transition over to Smartsheet, I'm keen to understand if anyone has found a…
-
Moving data from client report to my template
Hi - I'm importing client data to a template and I am using INDEX and MATCH formula =INDEX({Crane Range 6}, MATCH([Contra Firm / Sponsor Acct #]@row, {Crane Range 2}, 0)) This works well for one column at a time. I want to capture multiple columns at once so I'm not copying first name, middle name, last name, street…
-
How to use project status report and templates
Hi, I'm still new to ss and how to use free downloads! I'm stuck on how to use the Weekly Project Status Report Template like its shown in the image marked "report layout". I downloaded the template to which I have to complete the data (ref. image- "template layout". The issue is that I'm missing a key step to convert the…
-
Prevent Logic from Disappearing when copying a Form
I am trying to create a template for a form that my team will be using going forward. I've created a template and have all my fields set but when i save as new or build off the template all of the logic as well as required fields and Multi Line fields just go away. the Fields are still there but I have to go in and update…
-
Congratulations to the ENGAGE Template Contest Winners! 🎉
We wanted to give a special congratulations to the just announced winners of the ENGAGE 2022 Template Contest, your fellow Community Members and a few Overachievers! (Alison Note: We are not surprised by this at all.) During ENGAGE, Smartsheet put on a contest looking for one standout solution within each of these common…
-
Schedule Variance
How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.
-
Gannt chart help please
Hi, i'm using the excel template which smartsheet provide here: https://www.smartsheet.com/top-excel-project-plan-templates in the file ive downloaded the gannt chart looks lovely, however when i add in my project plan which has loads more tasks than the example, and over a greater time period the gannt chart severs no…
-
Formula to make it to check the checkbox in another sheet.
Hi all Hope you can help me. i'm trying to make a formular that can help me check off the checkbox in another sheet. So its going to be somekind of formular that looks into another cell and if it is checked off it is going to checkoff in that sheet as well. So 1. sheet is the Intake sheet. - The 2. sheet is the tasklist.…
-
Template Set: Marketing Request Management - Standards - Scope of Work cells
I am following the initial setup steps for the Marketing Request Management template set. In Step 2.C. customize the sheets for your project types and team, when I change the cells in the Standards - Scope of Work sheet, it breaks the communication to the Intake Sheet and Form, and gives me an error message "Incorrect…
