-
cell link to another sheet doesn't update
I have a cell link to another sheet. ( links are generated from Control Center) On several occasions, when the timeline date changes (source sheet), the link to the summary sheet does not update. When you are in the summary sheet and you double click on the cell, the source sheet pops up showing the correct data (date) ,…
-
Use index, match and left to match a set of strings from another sheet
Hello, I am using the formula below in order to match two data sets together. It works fine. For my next task I am trying to limit the match to only the first 12 characters of the string. I am trying to fit in the left function and using 12 as the character count, but I am getting errors. Here is the current formula I am…
-
How to link sheets so that the main page updates itself in a workspace?
I want to link sheets to other sheets. I have divided the workspace into multiple sheets so my team can work independently on their projects. I want their work to show up on the main page of the sheet. How do I achieve this?
-
Maps & Hyperlinks
I know that the smartsheet charts app is still in production, but is it possible to have sheet containing North American states and hyperlinks, then using the 'map' chart, click on a particular state and then it will take you to that hyperlink?
-
Issue with Cell Linking Automations
Hi, The issue I have is that one of the sheets we use is quickly gathering too many columns because we do a lot of reporting on the data and therefore need to capture information. We have a ticketing sheet through which a ticket can have 12 different statuses as it progresses, as it reaches each stage we wish to record the…
-
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…