-
Adding Cell Links to Existing Profile Data
For a period of time, 2 profile data fields were incorrectly set to One Time Write, rather than Cell Link. I need to correct this and add the Cell Link behavior for these 2 fields from the intake sheet to metadata sheets. I have tried the Add Profile Data trick to apply a pseudo Update Reporting Global Update, however that…
-
Limit increase: 500,000 inbound cell links
Hi Community, Now all users on all plans can add up to 500,000 inbound cell links in their sheets, allowing you to consolidate information by linking cells between sheets. Learn more about cell links. Catch up on how Smartsheet is investing in scale and reliability by reading VP of Engineering Gihan Munasinghe's recent…
-
Linking a cell issue
I linked a cell from another sheet that had a simple formula but the information doesn't show in the cell through the link. I have removed the link, saved then added it again. It's been saved and I've checked the font color. Any ideas?
-
Cross Link without Locking Cells
Hello, I have a main tracker (T1) and a sub-tracker used for only one team with limited view (T2). I need to link the tracking cells so someone can enter data on both sheets and it show up on T1. However, on T1 I have additional lines in the same column that require updating but will be locked if I try to run a column…
-
Total Time Spent On Various Sites
Hi I have a sheet that tracks time spent on multiple sites, I'm trying to add this to a metric sheet but struggling to get the metric sheet to add the total time spent against each site as a total. Can anyone help with the formula for this? Thanks
-
Hello,
I had a formula that was working all through the trials but then right before the roll out it stopped working! In one cell there's a column that Auto counts Responses no big deal there. In a cell in a different column =MAX([Row ID]:[Row ID]) // this counts the largest value so I can record the latest response In another…
-
Progress % based on status with cell linking
Hi I have two sheets, one acts as a master file for top level view only, the other is a more working doc. On the working doc, I have added a progress column, calculating the percentage of progress of the project based on the progress i.e. =IF([Activity Status *]@row = "Not Started", "0%", IF([Activity Status *]@row = "On…
-
How to Divide Across Sheets?
I am trying to take a value from the same column & row on a separate sheet and divide it by 160. I tried to go super simple and just do ={Sheet reference}/160 and got invalid. Any ideas on the best way to do this?
-
Can you cell-link within the same sheet?
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
Issue with Cell Linking from Metadata to a new sheet in the same workspace
I have an existing workspace for a project. I used the PMO template to create all my workspaces. I added a new sheet w/in the project's workspace and want to link the Project Name from the Metadata to this new Onboarding worksheet. The link shows up but the name does not appear. I've saved, exited, refreshed, etc. but…