-
Best way to track and plan task and projects in a dynamically changing manufacturing environment?
Help!!! I have been using Smartsheet as a novice user for a year now. I know that it has great potential to track and plan tasks and projects across multiple users and departments. I work in a manufacturing environment where every day there are issues that come up with production machines and need to be planned and…
-
Create SUMIFS formula with a contact criteria in a multiple contacts range
Hi, I am looking for the right way to build my formula that makes a sum of a number column with a contact criteria in a multiple contacts range. Example: =SUMIFS({numberRange with hours}; {Criteria Range with multiple contacts}; Contact Name; {Range with Statuscode}; "In Progress") Check also the screenshot below. If I…
-
Disable auto update of start dates for dependent tasks
Looks like there was a thread on this https://community.smartsheet.com/discussion/7262/forced-dates-when-dependency-is-enabled to disable auto-update of start dates when using the predecessor feature.. is this implemented?
-
Locking cells in sheet
Hello, I am trying to determine if there is a way to lock the formulas I have placed in my sheet so that the users cannot override them to hard key in numbers. The formulas have been entered into all of the necessary cells but as it stands, users can simply clear them out to enter the amounts in their own way. We have…
-
Control Center & Cross-Sheet References
Hello all, This is my first attempt at SCC provisioning of sheets and I ran into my first problem. There are three sheets in the blueprint -> Sheets A1, A2, & B. B pulls in data from sheet A1 and A2 via cross sheet references (index/match so I can reference by a key value in case rows move around in A1 and/or A2). When I…
-
Multiple Projects = Multiple Sheets?
HELP! Our company is moving to Smartsheet and I have very limited knowledge on set up and functionality. I've gone through the videos and read almost every tutorial and I know I have much to learn but the main question I have is the initial set up. I feel the set up is crucial and if I can get that correct, I can get…
-
Developing Library check-out list
Hi! I am looking for suggestions/help on a formula for a library check out sheet. In columns I haveL check out date / Number of Copies / Copies Available. I am struggling to figure out an automated process to get the copies available to update once when the number of copies is changed. When the form is submitted it says…
-
Linking Errors
Hi When I link out from my smartsheet to individual schedules it does not show the link anymore until I refresh and then it crashes. I get this error - see screenshot
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
How to show last passed child on parent row?
I have been trying different ways to show last passed "gate" of a project. The project can have from none to few child rows. There is a column with passed gates as tick marks. Now I want to show the last passed gate text side by the parent row. I haven't figured out how to do this automatically. Any help is welcome!
