-
Pause Time Tracked
I have a request to create a way to track a certain record's time since it's been opened, but the user would like the tracked time to not include when it's in a certain status. For example, if the record is in "Open" status for 2 hours, have 2 hours tracked. If the same record is changed to "Waiting on feedback", however…
-
Time Spent /Formula
Hello, I want to calculate the total time spent by each user to then create a graph. I tried a formula but it does not work. Can you help?
-
Can I make this use case work in Smartsheet?
Hi, I've been trying to solution a use case, and I'm curious if we can do it in Smartsheet. The use case is ordering materials for individual restaurants based on specific criteria. I was thinking that I can set up one sheet with the restaurant specific information (name, address, city, other required criteria), and a…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
SUM formula with extending range
Is it possibly to have a SUM formula in a cell at the top of a column, calculating the sum of the contents of that said column, with the range beginning at a specific row but continuing to the bottom of the sheet and extending down as rows are added to the sheet automatically? It would obviously be easier for me to just…
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
Hyperlinks in Linked Cells and Cross Sheet Formulas
I'd love to be able to add a hyperlink to a cell that links in a value from another sheet. Currently we're unable to do this as linking cells blocks the ability to add a hyperlink. This would add more versatility, particularly with trackers, as you'd have the ability to pull in valuable information while also linking to a…
-
Merged: Cross Sheet Hyperlinks
This discussion has been merged.
-
Be able to change finish date with automatic adjustment of duration or start dates
Once a project is scheduled using predecessors, Smartsheet automatically deleted the predecessors if someone manually changes a start (or finish?) date. Since we are trying to have team members be responsible for updating their tasks, it would be ideal if they could adjust their finish dates directly without the…
-
ISCRITICAL is FALSE for a PARENT task with CHILD tasks that are on the critical path
I have a project plan where the child tasks are on the critical path with ISCRITICAL = TRUE, but for the parent task, ISCRITICAL = FALSE. Is this expected behavior? Context: It's a waterfall project. Only the child tasks have predecessors and successors so that the dates and duration for the parent task adjust when the…