-
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?
-
Column Limits vs Data on a Single Row
TLDNR (short version) GOAL – everything in reports / sheets to be on one row per project PROBLEM – I run out of columns and reports won’t merge data from multiple sheets to one row. (long version) Typical spreadsheets can present as one project row and all it’s details in columns to the right (scrolling is left to right)…
-
Using multiple working days/resource schedules in the same project
Hello, As a construction PM, one of the functions I use most with SS is the Gantt style programming. I have multiple crews on the same project/in the same sheet, but the issue I have is they each have a different working schedule - for example night shift is Sunday to Thursday night, day shift is Monday to Friday, and some…
-
Summing IF and After 7
Hello, So I don't even know if this is something I can get a formula to do, but I am trying to get a number to check a cell reference and start summing if the number is above 7. But here's the kicker, I don't want it to sum the entire amount. I want it to essentially sum the number, minus that 7, but only sum the numbers…
-
nesting If. Can't figure out why I get unparseable error
Here is my formula. It is in a project plan: =IF(TODAY() > [End date]1, [% Complete]1 < 100%, "At Risk", "On Time")
