-
Trying to pull data from one sheet to another
I'm trying to get the most recent submission of a form (about vehicles) to pull the most recent mileage to our master vehicle sheet. I have tried several things, and I can't figure it out. =(JOIN(COLLECT({Most Recent Vehicles Check in/out Range 4}, {Most Recent Vehicles Check in/out Range 3}, HAS([ASSET#]@row,@row)),"-") I…
-
Can Created By Column be Wrong?
One of my users reached out because they received a notification in which they are ID'd as the creator of the project request, which they claim to not be. I checked the source sheet and they are indeed listed in the "Created By" column with a date about 1 month ago. You have to log in to enter requests in my form and I…
-
Include Column Origin in Properties
This request stems from my copying and moving rows from sheet to sheet. It would be very helpful for me to click on a column and see where the column originated from (Sheet name). If it was copied/moved and carried over from a different sheet, or if it was created within the current sheet. I'm running into very frustrating…
-
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.
-
Video Editing Software Discussion in Smartsheet Community
Hello Smartsheet Community, I wanted to kick off a discussion about video editing software, and how it can complement our project management efforts in Smartsheet. Here are a few topics to consider: Favorite Software: What video editing tools do you use? How do they integrate with your projects in Smartsheet? Tips and…
-
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…