-
Submitting Multiple Rows using one Smartsheet Form
We are creating a new Smartsheet to track deliverables. We have asked competing vendors to add delivery details within a ‘Smartsheet Form’ to auto-populate the sheet. Orders contain 1 to 100 shipments. Our Order Number is the same for all shipments. Ideally the vendor would like to enter the Order Number and the Order…
-
Has anyone used Smartsheet for production resource scheduling?
My company is still relatively new to Smartsheet. We have a project template that is working well for us. However, we also would like to also find a way to use Smartsheet to help us plan/schedule our production resources. We want to be able to line up projects, machine hours, and labor (non smartsheet users) so that when a…
-
How to Identify Duplicate Job Numbers on Multiple Sheets?
I manage 30 production projects across three Smartsheet sheets: one main sheet (Project Management) and two spin-off sheets (for Ordering and Install Certification tracking after a project ships). All sheets use a unique 4-digit job number for each project. What’s a formula or function I can use to quickly identify if any…
-
Digital Signature
Hi all, I've searched for this topic, but i could not find directly what i was looking for. Is there on Smartsheet any functionality for digital signature that doesn't require pairing our service with another software? All the solutions i saw were about using another software to do it, but those were from 2017. I am just…
-
Submission checklist to reference production schedule
Good morning, I have 2 Sheets Master Production Schedule - consists of multiple columns, Job #, Job Name, Line 2 Count, Forms Submitted?, and Status Check List Submission - consists of multiple columns, Job #, Job Name, Line 2 Count, Submitted, Outstanding Entries, Missing Form Override(Checkbox), and Status The idea is…
-
How can I capture the date and time of specific column changes?
I have created a workflow that goes through three different departments. I want to capture the date and time of a request (row) coming in, and the date and time of the next action and each action after that for cycle time purposes. Currently, I can track cycle time for dates but some actions need to be carried out within…
-
How to create a master sheet that can work-around the 20,000 row limit?
Hello Everyone! I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet. I cannot use Smartsheet Reports as a workaround since reports do not support formulas,…
-
Auto reference a file added to a folder that a Report is pulling from
I need help finding a way for my reports to automatically pickup new files. I have numerous reports that need to reference everyfile that is in a given folder. When these are first setup, it is very easy to select the folder for the "where" portion and it grabs every file within those folders. However, it doesn't appear…
-
Hello,
I had a formula that was working all through the trials but then right before the roll out it stopped working! In one cell there's a column that Auto counts Responses no big deal there. In a cell in a different column =MAX([Row ID]:[Row ID]) // this counts the largest value so I can record the latest response In another…
-
fx to auto pop TASK CATEGORY, single select drop down, based on parent row TASK NAME, primary column
I am trying to use card view reporting and sheet function sorted by TASK CATEGORY single select drop-down column. Below are 2 screen grabs, 1 is TASK NAME, primary column, children rows collapsed. The 2nd is with children rows expanded on 1 section and a simple fx I am using to copy the TASK NAME parent cell to the TASK…