-
Batch Editing
I would love to be able to select multiple tasks on a sheet and change the status if they are all the same. This could affect dropdown columns and date columns.
-
Update one sheet based on two columns from another sheet
Hello I have a request sheet and a review sheet. The request sheet generates a task number after submission of a new row. That task number will be manually inputted into another sheet. Once a review is done of the request, the user hits review complete. I want that checkbox (once its clicked on the review sheet) to get…
-
Merged: Lock Specific Cells
This discussion has been merged.
-
Merged: Conditionally Lock a Cell in a Sheet
This discussion has been merged.
-
Set Target End Date first and have predecessors fill in
Is there a way to set the Target End date in a project sheet first and have all the preceding dates backfill? When I tried it, an alert comes up that says "…will result in the removal of all predecessor relationships in this row". I've looked into the Workback Schedule using the Project with Hard Deadline and Gantt…
-
New Sheets defaulting to project view
Has anyone created a new sheet (grid view) in the past few days and had it default to a project schedule complete with status, start and end date, etc. filled out? I assume I've changed some setting in the background, but cannot figure out where. It's incredibly annoying and a time waste, since I'm not trying to create…
-
Sumifs- With a start and end date range Errors
I am struggling with this formula. My Syntax is correct, the lay of this formula works until I add my date range. I have tried having both my formula column and the referenced date column as date, dates restricted, as well as just Text/number. I have a years worth of data I want to calculate grand total of sheet, which is…
-
I need to create a high level project on a detailed project that contains a number of indented rows
I have tried to create the high level project sheet using linked cells and the index function however it keeps failing to transfer the information across. I need the sheets linked so that when information is added to the detailed sheet it will update the high level sheet
-
Chat notifications directed to reports
Our ECR solution is based on intake sheets with relevant data being brought into different reports depending on the users role. We make use of the chat function within smartsheet to communicate, but the notifications always direct the user to the underlying sheet. It would be great if we could re-direct the users to the…
-
Formatting issue with my rowID field, anyone notice anything like this before?
I've used this same formula in a few sheets now. In the past it's looked like the first screenshot below. Using the same formula in any new sheet I create it's now putting the expected values for the second line on a third line below the "-", seen in the second screenshot. Here's my formula: =Account@row + "- " + [Story…