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 disp…
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 wil…
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…
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 c…
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 vis…
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 JPE…
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 pha…