-
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…
-
Sharing Contacts
We currently cannot share our contact list with other users. This is very cumbersome for our company. We use Smartsheet to create a punch list for our vendors. We need multiple users from our organization to enter in punch lists for peoples, however, since I cannot share my contact list with my colleagues, we end up having…
-
IF(CHILDREN()) ? - Child inherits parent traits for entire column
I could've sworn I'd seen this but now I can't find it: We have a sheet for incoming project requests. Our general population can request multiple new mkt materials (printed direct mail, email, outlook MSG, etc.) for a campaign in a single 'ticket.' Then our PMO hotseat creates a new child row for each of those unique…