-
How can I add a reference sheet to this formula - I have build another sheet that I want to add up
-
Invoice & Budget Tracking for Construction Projects - using Attachments
This is an easy way to keep track of your invoices
-
Full Construction Management Set up
i want the system that was advertised in this video. how do i get it? (457) Smartsheet for Construction Demo - YouTube
-
Excel @Text() Functionality in Smartsheet?
Is there a way in Smartsheet to use a formula that gives the same result as using @text() in Excel? I have a spreadsheet that I need to concatenate several fields together and have the field then display as text. Most of what I see now for formulas is to covert from text into formula. But I need to go the other way? Use…
-
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…