-
Formula reporting from drop down list
I have a sheet that is used to track downtime in our production faclility. Essentially an electronic form is used to record how long the line is down in minutes, based the length of time reported I have a formula that makes an associated cell record if the amount of time represents a "major" or a "minor" stoppage. 5…
-
Holidays error
When I enter my workday formula =workday(receive5,-days5) it works fine. However when adding holidays, =workday(receive5,-days5,[holidays]) then it does not work. Do I have to enter the holidays manually? Does it not link to my holidays list I created? What am I doing wrong? thanks Mike
-
Auto populate cell information
I have built a sheet for tracking production downtime in our facility. I am looking to be able to streamline the amount of time it takes someone to entry sku specific information. So say the item has the following traits (Sku Number: 1035) (Flavour: Orange) (UPC code: 1234567890) & (Brand: Smiths) I would like to be able…
-
Track Date Changes & WBS
Dear SmSh, I have two issue: Issue One : We have submit our plan to client, then during implementation we have delay and date change. how to track the changes ? Issue Two: I found sample WBS sample https://www.smartsheet.com/free-work-breakdown-structure-templates here but couldnt found in the templete. how to draw box as…
-
Link two projects
Hi everyone, I have question that I have two different projects can I link them? Can I able to set Predecessor from one project to other? Thanks, Pranav
-
Sights access
Hi there, Does anyone know if Sights can be shared with people who do not have a Business or Enterprise account? Thanks, Paul
-
Parent Row Symbols based on highest priority?
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is "x" THEN action for symbol column is "low" = blue symbol is "medium" = green symbol is "high" = yellow symbol is "extreme" = red symbol I currently have a formula to…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
Count Number of Children Cells that are not blank.
I'm having difficulty with this one. I have a parent row of "Rental Lead" I would like to count the number of child cells in column "Training Course" under the parent "Rental Lead"
-
Multiple linking
I'm looking to select a row based off of 2 criteria searched for in the row, and return a third value in the same row. I feel like this is possible with the existing functions but for the life of me I can't seem to figure it out. This wouldn't be difficult with array equations in excel but i'm not having any luck…
