- How do I extract full URL from Hyperlink cell?
Hi all I have this Opportunity ID column in my sheet that's connected to Salesforce. All cells are hyperlinked with the opportunity in Salesforce. This column is created like this by the Salesforce-Smartsheet connector and it's handy because of the hyperlink. I need to send the Salesforce URL to another sheet, but if I…
- “从细胞在其他表链接”returning a "blank" - but the reference cell has info? what is h
Hello - This is a bit confounding, I have the links set up correctly and it returns a blank cell. I double check the source cell, and there is the correct information. Can anyone help? Thanks
- easier references to other sheets
Hi all, I prefer to use references of the form {sheet_name Range 1} rather than using the "link from cell in other sheet..." because the formula can be copied to another cell where trying to copy the direct-linked cell only copies the value, not the link. If I have a lot of cells all linked to a particular cell in another…
- Collect information from a changing database
I'm trying to find a way to search for information in a big database, but this database is constantly changing (new sheets imported with the API) The big database are split into 6 imported sheets (250 000 cells approximately on each sheet). This sheet is a list of products. I wanted to do a vlookup on these 6 sheets to…
- Limit increase: 100,000 inbound cell links for sheets
Hi Community, Say goodbye to a limit of 20,000 inbound cell links in sheets — now, all users on all plans can add up to 100,000 inbound cell links in their sheets, allowing you to consolidate information by linking cells between sheets. Stay tuned for more news about how Smartsheet is investing in scale and reliability.…
- Showing the dropdown list in the child row only
Hi, I would like to know if there's a way to show the dropdown list only in the child rows or to show a default value (from the dropdown list) in the parent row. Thanks, Kamil
- Pre-Approved Changes Pulled From Approved Standard Changes
Hello! I'm attempting to create a change management system wherein the pre-approved changes can reference previously submitted (and approved by our CAB) standard changes. Pre-Approved Changes - need it to be a drop-down list of pre-populated requests that are Standard change requests that have been approved to become…
- Celling Linking-Multiple rows
I need to link about 50 cells in my Inventory sheet to the SAME cell in my Inventory Price sheet. Can I do that as a group? I tried selecting all the cells in my Inventory sheet, then selected the linking option, navigate to the Inventory Price Sheet and select the cell I need linked to ALL 50 cells. Using this process it…
- Cell Link Auto-Refresh
I have a sheet that shows colleague productivity to individual colleagues that uses cell linking to ensure they only see their own information. The master sheet shows updates automatically throughout the day as their work is tracked, but the linked cell in their view doesn't auto-refresh unless you refresh the entire…
- formulas to reference sheet in multiple lines
Is it possible to bring information to a sheet from a reference sheet column but have it list the returned information out in separate rows? I have a source sheet with many rows that are sorted by status. I want to list out the job numbers AND the job name in another sheet, ideally side by side one on each row. I would use…
