-
Packing Slip Template Final
Hi, I am currently on this page and have downloaded the Packing Slip Template. I have opened it in smartsheet, but cannot find out how to make it look like the Final Draft that this page shows. Am I missing some feature?
-
Do Smartsheet Support an API to fetch header names of a template?
I want to make an API call to fetch the column names and respective datatypes of a user-created-templates.
-
How do I get formulas from a sheet pointing to a template to work when the template is saved as new?
I've got a template built for a repeating project format and I want to be able to roll up key fields from all of the projects into some combined sheets. The formulas work when populating the original project sheet but when I save as a new sheet, the link breaks. This is only a problem in breaking the links going from the…
-
Is it possible to automate link creation between 2 smarthsheets?
Regarding the question above, consider a scenario where 1 project requires 2 linked smartsheets. Now consider a scenario where 50+ projects each require 2 linked smartsheets and a new project is added to the que 2 or 3 times a week. Is it possible to have two "master" smartsheets linked to each other that can be copied and…
-
Formula to Roll Up Task Status
Hi All! I am looking for some help with a formula that I haven't been able to find in the community already. I'd like to roll up my Status column to the parent rows with the following conditions: Parent shows as Not Started if: All children are either Cancelled or Not Started. Parent shows as In Progress if: Even one child…
-
Can I make a template with sheets I already have?
I have been looking into saving my sheets as templates, and I think this would be a great option for our uses, but the problem is that all of my sheets for this year have been created. Each year I have 8+ large sheets with the same structure, and throughout the year we make some changes to formulas, add columns, etc. Right…
-
Building a Q&A sheet
Are there any templates for building an FAQ database?
-
Formula: if checkbox is checked then add or subtract
Hi everyone, I would like to have a sheet that tells me how many goods we have left in our warehouse. The idea is that employees report via a dashboard whether they are taking something out of stock or returning something. If one checks the column "IN" or "OUT" they also have to add the amount. That amount should be…
-
Intake sheets add on process flow task management aligning with project plan
I am setting up a sort of hybrid project with a large cable manufacturer, the project started and stopped during COVID and they had no task management. I am to use SmartSheet for the project plan, which I have mostly in place other than sites not visited yet. At the end of the day, I am standing up an OT network at several…