-
Multiple Forms on single Sheet
I am wanting to have a sheet that is going to have all of our production records on it. The office manager will enter all of the work order information with 1 form, and someone in Quality will enter the measurements on another form. If I have the Primary Column as each part's serial number, will the measurement info be…
-
Merged: Elapsed days as Duration with Normal days or weeks as Lag
This discussion has been merged.
-
How to link a value from Summary Sheet back to Intake Sheet
If I need the value from a Summary Sheet, to link it to the Intake sheet, is this how it should look like at the control center?
-
Global Referance point
I and I think alot of others really need this, We need to be able to have a global reference point so that we can reference across multiple sheets that have that same column . at the moment we can only refence one sheet at a time per formula example: =INDEX({MACH MAT}, MATCH([Row ID]@row, {MACHROWID}, 0)) If i want to find…
-
Control Center issue with cell links on summary sheet
I have an SCC blueprint with two summary sheets. We have several metadata fields, two of which are set up as cell links in the blueprint, the job number and job name. That way, if the job number or name is updated on the intake sheet, it automatically updates on the project metadata sheet, which updates the summary sheets.…
-
Sum values from child rows automatically with formula while allowing manual data entry into child row cells
We have a project plan with resourcing allocation built in to it (hours and budget) Currently we have a column for Allocated Hours where we are having to manually enter the below formula into the parent rows. I have figured out a work around by having a secondary column that I have hidden to sum the hours from the child…
-
Autopopulate Cells Else New Entry
I am trying to create a New Order Entry form. I have a dropdown list that references our customer sheet. If the customer is not listed, you can choose "(NEW CUSTOMER)", which allows more fields to open up to add the new customer info. If the customer is listed, can I have the address autopopulate into the appropriate…
-
Changes made to column titles
Automated flow when a cell or row changes exist already. I want to notify a person when the title of a specific column changes as it will effect dashboards that refer to the column title.
-
Dynamic Dashboard Filters
I would like to add two dynamic filters as a widget within my Dashboard to define a date range (start and end date) which would then return a count value to that same Dashboard. I have been searching for answers but am not coming up with the solution I'm looking for. What is the cleanest way to configure this?
-
How to do cell linking in new Smartsheet lauout
Trying to link cell from other sheet and I'm not finding the symbol for it in the toolbar. I have the new layout. Anyone know have to do that?