-
Automatic Duration column calculation + Linked Dates, is this possible?
Is it possible to have a "Duration" column that automatically calculates duration days based on End Dates that are linked to another sheet? For context these are my 2 scenarios: One: My Start Dates are linked to another sheet, my End Dates are manually entered, and my Duration column automatically calculates total days.…
-
Create a Form with Auto Filled
I have a sheet (Sheet 1) that is my Master Project. Each project has to create subtask request for another department (within Sheet2) but a lot of information prefilled in Sheet 1 needs to be fulfilled into Sheet 2 when the request is made to that other department. Is there a way to create a form within Sheet 2, use the…
-
Is it possible to add a link to a smartsheet item as view only?
I have one master sheet (my department overview) into which I want to add links to dashboards in multiple other workspaces (one per project). I have one row per project and it is very simple to right click, add hyperlink and choose smartsheet item, then simply select the workspace and dashboard for the project. However, I…
-
Create a dynamic link to "drill down" to a source sheet from a report
I know there has to be a simple way to do this but I'm not finding it and I getting into crunch time on this project so, HELP! :) I have a sheet that has a bunch of projects on it. I am pulling a report to a tracking sheet that folks will use as a starting off point to look at project progress. Whenever I add a new project…
-
Open a Hyperlink In Excel App
I have a sheet with a SharePoint link to an Excel file in a cell. When I click on that link, it opens by default in the Excel online app. Is there a way to change the default so that it opens in Excel's desktop version?
-
Anyone build a workaround to allow a click through from a SmartSheet to a fileshare
... not to OneDrive or Google Drive or anything online, just to a local fileshare. Our finance folks have a tool that builds analysis models. It needs to live on a local drive and produce output there. Anyone have a creative solution that would allow a single click to take someone to such a location. (Assuming they were…
-
Form Hyperlink in description text not working
Hello all, With the new text formatting abilities in the description box of forms, it appears the hyperlink button does not work. Has anyone noticed this or can help me figure out if I'm using it incorrectly? Thanks in advance, Rachelle
-
Automatically Create Report with Single Row Data?
Hello, Is it possible to use Smartsheet to automatically create a single row report and mail a viewable link? Use Case is similar to getting a package tracking number where the end user can view realtime progress on it with the unique link/identifier Below is the idea I have sketched out, but I have not found a way with…
-
Show url as a text link or button?
Hi, is it possible to show a url as a text link or button instead of the full url? Thank you Kim
-
URL instead of Display Text for SCC Project Dashboard?
When a project is provisioned in SCC it generates a dashboard link using whatever naming convention is setup in SCC. It doesnt appear to have any options in SCC to make it appear as a url instead? I also am checking the column properties or formulas for a way to make this a URL? The problem is that once a Dashboard Link is…
