-
autofill linked cells
I have a Master sheet with job rows that number 1to17, next job starts on 18 and are the same rows of data. These continue as such for subsequent rows. My other sheets link to certain rows on this Master. For example row 17 is always "Shipdate", so my "ShipDate" sheet links to row 17 on each job so I can have a calendar…
-
sum time total time reported today per production line
I have sheet that is being populated by data being entered into a form. I have columns for "Date" "Production Line (text field)" and "Stoppage Length (time)" I am trying to come up with a formula that enables me to sum the total stoppage length each day per production line. I created a formula that uses the sumif formula…
-
IOS app not opening web forms
I have built two web forms for use on our production floor. I have an issue where the forms will not open in the IOS app. The URL opens if opened whilst in smartsheet on the PC of when click the link from an email, but just wont open in the IOS app. Any advice? Anyone else had this issue. Thanks Jon
-
Excel to Smartsheet WORKDAY formula
Here is my excel formula I use to find a FRIDAY shipping date. =WORKDAY($T1165,-10)-1+(WEEKDAY(WORKDAY($T1165,-10)-1)>=6)*7-WEEKDAY(WORKDAY($T1165,-10)-1)+6 I changed to this in Smartsheet but doesn't work. Any advice? =workday([start date]12,-10)-1+(weekday(workday([start date]12,-10)-1)>=6)*7-weekday(workday([start…
-
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