-
Unable to Change or Delete Any Dates
I am unable to change any dates in my project schedule. It does not matter if it is a blank cell, automated cell, manually entered cell, new line I create, existing line, etc. — no matter what, if I attempt to modify a date, it just enters as 9/11/2025. This started last time I used my file. I have made sure cells aren't…
-
Links Not Working
Anyone else having issues with links to other Smartsheet sheets not working on and off? This is the second issue I have had this month. My table is not populating with the little arrow for the link showing as red versus blue. Error message says: Error: this link is invalid because the linked cell has been deleted. But, if…
-
Primary column data to other Sheet
I have 2 sheets, Sheet A has Primary column and I want to copy Sheet A primary column to sheet B. Sheet A has 2000 lines in primary column also whenever I update Sheet A primary column I need it should be updated in Sheet B too. how I can do this in Smartsheet?
-
Linking two sheets in a very specific way
Hello all! Like my title says, I am trying to link two smartsheets in a very specific way. I have a process in which I have individuals requesting support for specific courses this is tracked in one sheet. I then have a second process that hires people to provide support for those classes. Where I am running into trouble…
-
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…