-
Limiting editable access to certain users
Hello there everyone interested! We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users. Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns…
-
Resource Allocation in Manufacturing
Hello, I am curious if anyone has tried to use Resource Allocation for capacity planning in manufacturing. Our projects are long term releases against blanket orders and I would like to use the Project Sheet to view where Production/Manufacturing resources are over-allocated and prove the need for additional staffing or…
-
Gant Chart Time Dependencies - Hours
Please let me know if anyone has figured out how to get the gant chart down to hours. The minimum that I have seen is at days and then it goes to weeks, months, and years. We have a project that will have dependencies on certain days that go down to the hour.
-
Images in Templates
Is it possible to save an image in a template. I have tried but they disappear. I have all options ticked. I understand that I can attach them but visually it would be better for a small image to be shown against the item name. Would this be something that could be done in the future to save having as an attachment and…
-
Create JitBit Ticket When New Hire Form is Submitted
Hi all, I'm very new at Smartsheets, and have just created a New Hire Form and I would like it to create a JitBit ticket when the form is submitted. Is this possible? Thanks in advance!
-
Manufacturing Scanning
We manufacture an industrial machine. As the system moves through the process at each station we would like to update the status of each machine with a qr code or a barcode, and trigger automation rules ie send emails or alert for issues if they come up. We want in the future to populate the smartsheet with info from…
-
Filter default settings
I use up to 5 sheets at any one time, each containing information relating to different customers. I frequently need to filter information on any particular sub-client via a text/number column. The default ‘Create New Filter’ uses “contains” for me to enter a unique name of the sub-client, and all rows applicable to that…
-
produce a report.
Hello, ive been asked if we can produce a report with the percentage done column like the illustration shown below?
-
Count Formula
Is there a formula I could use to populate a number into a cell that is a counter of workdays since job has started, and it starts counting once a check box is checked off and stops counting when another check box is checked? this way we can keep an eye on our time frame of a job from start to finish
-
Modified Date and Conditional Formatting/Alerts
I have hit a problem that Smartsheet can't seem to deal with. My goal is to create a sheet that runs conditional formatting based on the differential between 'Modified date' and a TODAY equation. Firstly I tried to create a TODAY based formula in the conditional formatting tool. However, this acted as a figure once…
