-
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…
-
Sheet Summary
I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?
