-
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…
-
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…
-
Help with TIME() Formula
Hello, I am testing out the TIME() function and working on a formula to determine the amount of hours and minutes elapsed between a Start and Finish columns. I thought I had it figured out, however, I noticed that for my row that has a Start time of 3 pm and a Finish time of 5 pm, it was showing a time difference of "1…
-
Naming Manager, Data Slicer, and Table reference functions for formulas, and LET, Unique, Sequence
Excel has leapfrogged Smartsheet in terms of ability to utilize data set, naming manager, dynamic data slicing, Dynamic Table formatting in excel sheets and new formula types LET used with Naming Once as reference, Unique provide back only unique values, Sequence able to order data values via formula, and several other…
-
Autofill child row cells with information from parent rows
Hi! I am trying to get my Smartsheet to autofill information in some cells based on the parent row. The sheet is mainly viewed in card view so when my teammates add subtasks they don't fill in basic info like the team working on the project since that is already in the parent task card. I tried a basic =parent but that…
