-
2 Conditions on 1 Status Indicator
I’m working on a project where I need to have to 2 conditions on 1 status indicator. * 1 for tracking duration against today's date: =IF(NETWORKDAY([Start Date]9 + 1, TODAY()) / Duration9 <= [% Complete]9, "Green", "Yellow") * 2. Tracking if a task is not completed on time: =IF(AND(TODAY() >= [End Date]10 + 1, [%…
-
Attaching OneDrive File
I'm having trouble attaching OneDrive files, but have basically narrowed it down to not being able to attach files that were shared to me from someone else. Problem is my boss creates the main folder then shares it with me and we work like crazy out of that one folder. So does this mean that unless I am the creator and…
-
insert key
My insert key does not add a row. it only deletes what ever is in the cell of the row that I'm in when I use it.
-
Calculating total hours worked in a shift
I'm trying to create a weekly work schedule for all of the employees at our company, so that we can see the start and end of shift and total hours worked per day and per week for each employee. I contacted the Smartsheet team only to find out that Smartsheet doesn't currently support time based formulas (which is such a a…
-
Start & Finish dates based on separate predecessors / or formula in duration
I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a start day based on the production start line and the finish date be the last ship date.…
-
Returning a cell value if false
Hello all. Pretty new to Smartsheet here. I am trying to create a call that checks if one column, Trip, contains a value 1st, if it does NOT contain the value 1st, I want it to populate the contents of the corresponding cell in column Job Description. I keep running into errors attempting to nest the cell call =[Job…
-
Smartsheet Barcodes
Hello All, I have a sheet that has a specific barcode for each card. Ideally we would use the barcode functionality to scan an item, then select the option to bring you to the correct card. With it set up, when I go to test it, it only works occasionally. It will usually only bring me to the column that the card is in and…
-
Financials: projected, actuals and variance
Hi! Very new to smartsheet and looking for any preset reports for tracking 3-4 year project financials, specifically projected spend, actuals, and variance. Does smartsheet have this type of reporting? Thanks!
-
Combine Form Row information into Single Row data
Hello all. We are looking for a way to take rows entered via webform and then merge the information into a single row of data. To give you an example of what we are doing. We enter a building Number (currently Primary Column) and a unit number into the form. There are then unique items we are checking off in the form or…
-
Sorting
Hey Guys, I have created a sheet to help our construction company track our new leads. We have set it up to fill out a form that feeds information into the sheet. I have conditional formatting set up to identify each lead by their status. Periodically I will pull out dead leads and move them to a parent category allowing…