-
Lock a shared sheet into a standard format/setup
It would be great to eliminate the frustration of your view on a shared sheet being rearranged by cell width and wrapped text done by another user. Individual users should have the ability to save their own view of the sheet, or clear all their customizations and have it revert back to the original default view. Could work…
-
Is there an easy way to build a report with same order of columns.
First off - I am more than experienced at report building. But when it comes to a sheet that has 250+columns, picking the columns in order you want them in your report is very tedious. The other option is click and add lots of columns and then drag them into their right sport/order, which is even more tedious. There should…
-
Can a Form have multiple entries and have them display as multiple lines on the smartsheet?
I have a form I'm using as a maintenance work order log. I have them fill out a form, which in turn fills out the order log. Is there a way to have them enter multiple parts and descriptions and have them populate on multiple lines in the smartsheet order log? If they do have to enter a form entry for every part they want…
-
Check box for parent row only
I have a sheet where there is a helper column that says either Parent or Child. If the helper states "Parent", I want the checkbox in a column named "Report" to be checked. Otherwise (if the Helper states "Child") I want the checkbox in the "Report" column to be unchecked. Can this be done with a formula or conditional…
-
Merged: Smartsheet Application Zoom Function
This discussion has been merged.
-
Helper sheet no longer populating
We have a helper sheet that absorbs certain orders, entered by a form, to fill another sheet. It is no longer populating. The only thing I know has changed is that some column names on the main sheet had been altered in order to set up an automation for a totally different sheet. Nothing else appears to have changed. Would…
-
Merged: Reports Calculated Field
This discussion has been merged.
-
How can I link predecessors from one sheet to another?
A task in sheet A is required to be completed before a task in sheet B can be worked. Is there a good way to do this? Note: I also have a master sheet that is fed from the values in sheet A and B combined. I want to be sure the integrity of that link carries over into our master sheet. Thanks!
-
Automate sheet creation
Can I use automation to trigger the creation of a new sheet? Here's the situation. I have a form that adds a new row to a sheet. I would like to evaluate the primary key's value against what already exists in sheet and do one of two things: if the value already exists add the row to the existing sheet for that primary…
-
Difficulty with number vs text format, especially when using primary column as match range
Currently I have a primary column in sheet 1 which is a value of 3 digits, all of which are numbers. These numbers are generated by the auto-number column type. I attempt to use this primary column as a match range to pull information with an index & match into sheet 2. Performing a test using ISTEXT on sheet 1, all…