-
Best method for linking 2 sets of data together that use forms to collate the information?
I'm working on a project to help devise a solution to track all of our organisation's skills & talent initiatives, plus that will provide us with some useful metrics. The plan is have 2 forms - part 1 that collates all of the schemes' information and then a part 2 that collates information on outputs, but which is sent…
-
Why can't I link the "End Date" from another sheet? What makes this column unique?
-
zzTakeoff Integration
Can I integrate this with zzTakeoff using ai? I have large customer moving forward with zzTakeoff who is looking to move away from excel to google sheets. SmartSheets seems like a better fit and I would prefer to suggest a product that has a live link. Has anyone been able to use AI to create integrations with SmartSheets…
-
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…