-
How do I get my datasheet to show the months requests were opened and closed
when my request tracker sheet's input is in calendar format? Current set up is as below, and I'd only like to use data from column A & B to ensure better accuracy in the data sheet:
-
Hyperlink to a network drive
Hi - I have a document stored on a shared network drive that I would like to be able to insert a hyperlink to. Is this possible with Smartsheet? The sheet appears to only accept web addresses as hyperlinks rather than file locations (for example: Z:\Documents\File.pdf). Uploading the document to a cloud storage provider…
-
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…
-
Date Cell linked
Hi, When linking a date cell from a gantt to another date cell on another gantt, the date format changes and I cannot make it right - whereas my personal settings are the same, over the whole of smartsheet as well as on the independent gantts - can anybody help please?
-
Using Salesforce connector to sync go live dates and drive dependencies
Hello Smartsheet community, My team uses Salesforce as the system of record to help identify which Salesforce projects will be provisioned in Control Center. One of the problem areas is that go-live dates can shift and it's a pain to update the Smartsheet side if I'm already using Salesforce Connector to pull in the Target…
-
update a cell with the last comment from a conversation
Hi All, We have a smartsheet file, where we have enable conversations on each row. I want to find out if it's possible to automatically move the latest comment from the conversation to into another cell on the same row. This way users can see the latest comment without having to open up the conversation. Many Thanks,
-
Cell link data from helper sheet to a new sheet
Hello, I have an initial sheet (Sheet A) automation then copy's (status triggered) rows to a helper sheet (Sheet B). Cells from helper sheet (Sheet B) are linked to a new sheet (Sheet C). I am now looking to automate this process where each time a row is copied into Sheet B the same linked cells from the new row copy to…
-
I need to Sum a column from a reference sheet and display the number in my primary sheet
I am attempting to build a column formula that generates the sum of hours for a given phase (task). This is an interaction of our Main project grid and the Timesheet grid (it is one of the advanced reports Resource management offers) from Resource Management. Our main project should display the number of hours incurred for…
-
Cell-linking from another sheet in the Predecessor column
Please enable the ability to use the cell-linking from another sheet in the Predecessor column. Importing dates from another sheet in a new row and then using them as a predecessor can disrupt the duration and critical path of the project. Thank you.
-
Linking a field in a form to a source sheet as picklist
I already put in a ticket and got the answer this is currently not possible, but was encouraged to put in a post here to hopefully being integrated one day. In my situation we have a huge list of project names (and constantly growing) that we'd like to be able to pick from in a from related to a SmartSheet. We find that…