-
Scheduling and Dispatching
I want a master calendar so I can see where our in house crew is working and other individuals so I may schedule them throughout multiple jobs. Now, we use individual sheets to gantt construction jobs. I want to find a calendar program (because SS does not have time stamp) were I am scheduling resources through out the…
-
COUNTIFS Issue
We are using a sheet with count if formulas in order to graph progress on a dashboard. On the source sheets we have a dropdown menu with the following status options: * Prep * Working * Decision - RENEWING * Decision - MOVING * Housekeeping * CLOSED The COUNTIFS formula we are using works for all of the status options…
-
COUNTIFS for year within criteria
I am pretty new to using formulas. I'm working on a dashboard for one of my sheets and I want to show how many escalations a plant has had this year alone. Here is what I have so far: =COUNTIFS(([Plant]:[Plant], "Changzhou"), IFERROR(YEAR(@cell), 0) = 2019) I've tried many different variations based on my scouring of this…
-
External Inputs
What types, if any, of external input from other programs is SmartSheet capable of handling/using? IE, is there a way to set up a sheet so that whenever a certain program updates its information your sheet does as well? If so, what types of programs function in this way with SmartSheet? Is it limited in scope or is there a…
-
New Here; Automation question
Hi, I'm excited to start using Smartsheet to manage all of our workstreams and related tasks and issues. I was wondering if there is a way to automate the setting of one field based on another, so a row update? E.g. I mark a task Complete and it moves it to the (card) list Completed? What I'm finding in automate workflow…
-
Allocation of Resources by Hour
Scenario We have a smartsheet that tracks multiple projects (ROW) and we have resources allocated to one or many of these projects. In any given week, these resources are allocated on VARIABLE HOURS not %. Currently the smartsheet has % allocated for its Resoure Management View and it doesn't consider the HOURS (a total of…
-
Multiple IF/AND statements
I am a new user and struggling with some IF statement rules to set color status. For the most part, I am pulling from the status column called “Capability - Stage Gate Status”. Users choose from a drop list. In addition, I wanted to add some criteria for other scenarios, such as the Start Date is past and % is 0%; the…
-
How can I create drop downs with selections based on a previous column?
For a product management file, I want drop-downs to be limited based on how a previous column is filled out, as it would be a massive dropdown list otherwise. For example, if "fruit" is selected in the "food type" column, I want the next "sub-type" column to have a drop down list for apples, bananas, grapes, oranges, etc.…
-
Invalid Value Error with New Year
Hello! I have created a formula for 4 months after a specified date column. The problem is, when that 4 months goes into next year, I receive the "#INVALID VALUE" error. For example, if my formula is using the date of 08/31/19, I receive the proper formulated response of 12/31/19...but if I change the date to 09/01/19, I…
-
Barcode Scanner not showing Barcode Picture
I am trying to update our inventory system to Smartsheets and I want to take a picture of a Barcode and instead of geting the picture of the Bar Code I am getting just the numbers. How can I go about fixing this?