-
hyperlinking to a folder and or file on our local network drive
I would like to hyperlink a folder to our company shared drive from smartsheet. I keep getting the error message "Invalid URL" I have seen from other comments that this is an issue, is this some feature that may be added by smartsheet? It would greatly benefit the way we could use smartsheets. Thanks for your anticipated…
-
Billing Projection
All, Inquiring about breakout of 'Project Contract' to populate evenly across months based on 'Last Day of Start Month' & 'Last Billing Period.' Ex: Project Name 24006 would show $113,915 in June, July, and August to equal $341,745. Perhaps an added column in sheet is needed, that already has the even split sum. Attached…
-
Real Estate Project Management
Hello, is anyone working with a real estate/construction project management template dashboard that they have found helpful? We are a project management firm and we are having trouble finding dashboards that meet our needs.
-
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.