-
Predecessors and Formula's Error when I delete rows
I have a master sheet that has tasks for all types of projects and depending on the customer we sign, I will go through and delete the rows I no longer need. The issue is that my RYG (error: #BLOCKED) and Predecessors (error: #REF) error when I do this which means I then need to go back and correct them manually Is there…
-
Automated send format question
Good morning, I'm setting up an automated weekly send for a report. I need send it in the vertical format, as though you are sending a row. As it is, it sends in a PDF which is a linear format, and not user friendly for our purposes. Is it either a: Possible to send a vertical format on an automated/recurring basis or b:…
-
sheet stopped functioning
I have a 2000 line schedule and this morning a lot of the parent rows are no longer showing the summary dates of their children. Which ones seems to be random. For columns in which I do math on the parent row that is missing summary data I get #Blocked. Need help please.
-
Links not updating
Hi All, I would appreciate it if someone can help me out. I double checked that my links are linking to the correct areas between two sheets. But it is not updating the sheet it links to. Please advise and see screenshot. Thanks, Y
-
Getting top x rows
Hi all We're working on a dashboard for senior stakeholders. At the moment we have a report that is an amalgamation of several sheets (listing risks & issues). We now want to limit that amalgamated report to only show top x rows, based on one of the columns (numerical value). So, instead of the current report showing all…
-
Conditional date formula
Hi, I'm having a little trouble creating a formula for a date column. I have a 'Project type' column and a 'Project start date' column which need to determine what the 'Handover to support date' column is. Basically - for all projects the 'Handover to support date' has to be 1 month after the 'Project start date' apart…
-
Cell linking within a sheet
Hi there, I understand that you can link cells in Smartsheet between sheets, but I have been unable to link cells within a sheet - does anyone know if this is possible in any way? Thanks, Paul
-
Formula Help
I have a formula that says it is an incorrect argument. When I break up the two arguments they each work, but they are not working together. The error message is incorrect argument. I don't know why they work alone, but will not work together. Here is what it looks like when I added them together. Can someone tell me why…
-
Pulling data using web query file
Hi I would like to connect smart sheet to netsuite. Currently i am doung it through web query in excel. Does any body know how to get data into smartsheets using standard web query file? thanks
-
Live Data Connector Reverse Upload
I have the data connector up and running. I am able to have it take info from Smartsheets and put it into excel. This is awesome because one I press refresh it updates everything in that excel file. The only question I have is, is there anyway that the data can be updated into smartsheets if I change it in excel? We have a…
