-
Weekly Input for multiple data points at multiple sites
We have been tasked to gather weekly meter data: multiple meters (3-10) for each utility (water, electricity, natural gas) at each of the 60 plants. What is the best way to gather multiple data points from mulitple plants all at once? We are unsure how to format this correctly. The plants will have to entrer Meter Name,…
-
Search using wildcard* not locating content in a sheet
Hello, Today a user asked how to make the searches in a sheet less restrictive. I offered the wildcard as a solution and as we were walking through the search it found 0 results. Within the sheet I have a column with a customer part numbers including revision example: 111-111111_RevA. I perform a search for the part number…
-
"Red" traffic light disappeared
Hi there, I'm currently using a "Red/Yellow/Green" traffic light status in one of my sheets, with the colour that is displayed being based on certain criteria. I've just noticed that the "Red" symbol does not show when it should (it was working fine before; "yellow" & "green" are still working ok.) I have not changed the…
-
Filtering with Start and End date views
I have filters setup to view different tasks on separate calendars. However it only shows the StartDate. Is there a way to enable EndDate as well?
-
Kanban: Delete Columns / Edit Column Values
Can you delete some of the default fields in a Kanban if you are hoping to use it in a nontraditional way (e.g. assigned, size, etc.) Addendum: not finding how to delete any fields actually, even those manually created. Addendum #2: not finding any way to update column values after they've been created. I'm striking out!
-
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…
