-
How to write VLOOKUP to source data from multiple sheets
I have a Master Project sheet and multiple individual project sheets. I need to gather one piece of data from the individual project sheets to write into the row on the Master Sheet. While VLOOKUP will work, the wizard requires me to know the sheet that I want to search. I need to reference all sheets in a workspace as the…
-
Batch uploading to drawing register
We use smartsheet for our drawing registers but are having to upload each drawing individually. Is there a way to upload drawings in batches and each one automatically upload to a different row. It is very long winded at the moment the way we are doing it, especially when then having to input the relevant drawing numbers…
-
Unhide all columns
I need to be able to unhide one single column. NOT ALL. Is there a feature where I can pick the column I need to view. We have weekly columns that go back 2 plus years. I do not need to see over 100 columns unhidden. The unhide all feature is not useful to our business.
-
Vertical line in Gantt - Data Date
It would be great if there was a way to add a drop line on the Gantt view i.e a vertical line that communicates important information like the data date i.e the date the schedule was updated These visual tools are important for consultants when trying to communicate data to clients etc
-
When will a "quick view" for .HEIC images be available?
Many of our team members have iPhones and the new photo format apple is pushing is .HEIC. When we upload their photos to the attachment line they are not able to be clicked on and viewed the way a JPEG is. Seeing that this a new direction in photo formatting, when can we expect a "quick view" the way we have with JPEG…
-
How can I change the WBS phase number for my WBS by phase?
Hello, I am trying to figure out how to change the WBS phase number for specific tasks in my project. For some reason a group of about 15 tasks is assigned to phase 1 in my WBS, but they should be phase 10. The WBS number is showing 10.1, 10.2, 10.3, 10.4 and so on, but the phases for these are locked in. How can I assign…
-
Enhancement Request for Smartsheet Proofing Features
Hello Smartsheet Development Team, We would like to request enhancements to the Smartsheet Proofing features to better facilitate the processing of RFIs and Submittals in the construction industry. Currently, due to limitations and licensing requirements, we have paused using this solution and reverted to manual data entry…
-
Procore and Smartsheet Sync for Budgets/Forecasts
Hello, We're starting to integrate our construction team into our broader Smartsheet project pipeline for new construction projects. I'm wondering if anyone has had any success or guidance on how to pull budget and forecast data from Procore into Smartsheet. Thanks, Dylan
-
Form Submissions: Multiple Condition IF Formula Isolated to Most Recent Only
Hello Friends! I have a form that my field crew uses to check the condition of our machines every morning, which includes the most recent hour/meter reading. There are (5) machines that we own that I want to isolate the most recent reading into a dedicated cell in order to determine how soon the next service will be. Also,…
-
How To Have Risk Column Automatically Update Based On Certain Conditions
Hello, Can anyone help me write a formula based on the following conditions. Risk Status = "Green" if the following conditions are met: [Delivery Confirmed] is checked Risk Status = "Gray" if the following conditions are met: [Release Date] is Blank Risk Status = "Red" if any of the following conditions are met below:…