-
Paste Special > Links to copied cells is greyed out
Hello My option to paste special > links to copied cells is always greyed out, even when trying to paste into the same sheet and column. I've tried different browsers and sheets. Any help gratefully received!
-
Sum for a Coloumn based on Multiple column categories.
I have this meta data sheet that shows all the information from a form being submitted, and im trying to gather sums of specific resources based on their qualifiers into another sheet thats easier to others to read. Example would be I have a resource that has multiple configurations and im trying to separate those out…
-
Auto-Rescheduling Tasks (Based On Tasks Being Dragged)
Please see attached screenshot on just a draft option on what I am playing around with. I want to drag Task 4 to actually be Number 1 priority and for that Task to be completed 1st (however I don't want to use the Dependencies feature as the tasks are NOT linked, they are all separate) and I want the dates to all change…
-
Refresh list of sheets to link to
I am creating lots of sheets that I need to link to master sheet. Each time I create a new one, when I go to the master sheet and click "link from cell in other sheet", the newest sheets are not showing in the list and there doesn't seem to be a way to refresh the list; instead, I have to refresh the whole page, which…
-
Cross-sheet reference option not appearing in formula editor (Pro plan)
Hi, I’m on the Smartsheet Pro plan. In one sheet I have a column called Status (with dropdown values such as “Building permit received”). In another sheet, I want to count how many rows have a specific status using COUNTIF. According to the pricing page, cross-sheet references are available on Pro, but when I type…
-
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…