Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Collaborators can't access the project sheet
Hello, I'm new to the application. I've created a list of collaborators and sent out invitations. A couple of them have recieved the invites but don't have access to the project sheet when they accept and log in. This has not been the case for everyone. Any troubleshooting recommendations? Thanks, Ryan
Contact Database
Hello! I'm new to smartsheet. I was wondering if there was a way to click on a company name and have it display all of the contacts associated with that company? I understand that you can link cells and link sheets but I don't want to create a sheet for each company. We have hundreds of companies and hundred of contact…
Copy links
I use link between sheets a lot. Sometime I have to link to the same cell a lot of times - but it is not possible to just copy another cell with a link. Could this be a possibility? It would make my work much easier, since it takes time to make the link to another cell in another sheet. Thanks.
Calculate a whole number with a remainder
Hey All, I have a column that calculates the time a vehicle is in our fleet. It returns a whole number such as 500 days. Is there a formula that will convert that to number of years with a remainder being the number of days. (1 year 135 days). Any help is much appreciated. Thanks Dwayne
RFI integration
Do you know if RFI chips in folders could be integrated with SS? Thanks for the info!
Attachment previews
I am wondering if there is any plan to add attachment previews as an option so that users have the ability to download just the document they may need from among others.
Rollup Reporting - Escrow System
I've created a set of templates which are essentially extended to-do lists for tracking real estate escrows. Each new escrow gets a fresh sheet inserted into the <active escrow> work group. The user is responsible for adding the new sheet to the master report. Beyond that, I can't ask uses to create links or other…
Is there an easier way to request backups?
I create several projects a week, and I would like to stream line the backup request process. Instead of right clicking on each project worksheet and selecting both Request Backup and Schedule Recurring Backup, is there a way to do this for several projects at once? Or better yet, when I "Save as new" a project, can it…
Linking blank cell
Hi, I am not being able to link a blank cell to another sheet. My goal is to make data of few columns of other two sheets identical to the data of master sheet, where my team will fill the cell with data later [Currently it is blank] OR is there any way that i can link the column itself to another sheet ? Thanks. Deepak.
Using Calendar Days but, not including weekends or holidays for my end dates.
I believe that I may have asked this in the past but, in the legal profession we use calendar days for calculating dates but, do not want the completion dates for most tasks to fall on a weekend or holiday. Any solution to this? I came up with some fancy formulas to do this but, because Smartsheet uses its calculated date…
