-
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…
-
Status Report based on certain conditions, i.e. dates, status etc
Hi Smartsheet community, I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!! For example: Project A Status Report for the period 04/Nov/19 - 17/Nov/19 What I want to show is: 1. Completed…
-
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…
-
Formula for Length of Day
I need to get the "Length of Day" that is set in Settings so that I can perform some time calculations on the Length of the Day set for the project. Is there a way to derive this?
-
Flagging duplicates from 2 separate columns
Greetings - I'm having an issue trying to flag duplicates from 2 separate columns in the same sheet. I have been able to flag duplicates in a single stand-alone column but trying to using the same formula with the "COUNTIFS" function is leaving the flagged cell blank (as seen in row 2 of the screenshot attached). Here is…
-
Reassigning tasks in bulk to a New Resource
Hi, I have assigned multiple tasks to Jane, but I a new person is now taking over all of Jane's tasks. So is there a way I can bulk assign all the tasks and the sheets to the new person? Thank you!
-
Smarsheets/JIRA Integration Question - not yet using JIRA Connector
I have a Smartsheets survey form that gets automatically sent out in a link via email when JIRA tickets in a specific project are closed. Our JIRA admin folks setup that automation, as we do not have the Smartsheets JIRA connector. The question is, when a new survey form is filled out, the entry loads into the Smartsheet,…
-
Maintaining template formatting on Dashboard
I have a dashboard I saved as a Template - when someone saves as new and uses that template as soon as they edit the widgets the formatting is lost. Is there a way to maintain the dashboard formatting creating in templates?
-
Permissions to edit cells
Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status. The question is possible edit permissions on cells to avoid that any user could change it? Thanks
