-
Automating a way of understanding time difference when start and end time are in the same column.
Hi everyone, We are looking at using a smartsheet solution to understand how much time employees on our production lines are spending working on certain lines. I created a separate sheet for each production line (we have 12 production lines) and I am using QR codes scanned via a smartsheet form (Quick for employees to…
-
Auto Refresh Data?
I have developed a web form for a sheet I am using to collect production data from our production lines. I am then using a smartsheet sights to display production data on a dashboard I have published. I may be wrong, but I think the sheet that the data is being sent to needs to be manually refreshed so that the sight will…
-
Nested If with Multiple Check Box to Status Type
I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category. IF([Done]@row=1,"Done" IF([On Deck]@row=1, "On Deck" IF([In Progress]@row=1, "In Progress"…
-
How to keep cell unchanged in status column
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…
-
Nested If with Multiple Conditions Automation for Project Management
Hi SS Community! Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. Currently, I have this: =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On Deck", "Not Started") I just…
-
Best way of Counting a given number of States
Hi there, I am trying to have a graph display the count of some things across multiple sheets (~40), as shown in the screenshot. The only way I could think of for now was to get the data by cell linking and doing some calculations on it in an extra sheet. As it turns out now, doing all of this "manually" for multiple…
-
Gantt View Timeline Zoom
I want to be able to view my gantt chart more zoomed in. Is it possible for me to have my primary headings as days and secondary as hours? Or is the furthest you can zoom in weeks and days?
-
Sharing Report to non-licensed users
HI, I am trying to share a report to users (not licensed) but can only get them to see the sheets in the report if I give them a license. I have shared the relevant sheets with the users. Before we signed up to the paid account this was an option. Thanks, David
-
Automatically update form link when creating new folders
Hello All! I have a folder template that has a sheet with task tracking. I have forms for entering certain tasks, Internal, External, and SCRUM tasks. Currently, I have a link to the form on a dashboard, however, the link is static and does not change when I copy the folder template and make a new project. Is there a way…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
