-
Intermittent #blocked error
Using the formula below in combination with predecessors (FS -5d) I get an intermittent #blocked error. Sometimes when I make a change (add a date / change predecessor) it goes away. I can make a change, undo the change, and the error is gone. What am I missing? =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red",…
-
Web Form Autopopulation via URL
I am having problems with creating new URLs to auto-populate web forms. All of my old ones still work, and the regular web form functions still work, but I get an error stating the form is no longer active when I try to add information to the end of the URL. Is anyone else having this error?I am 100% sure my formula is…
-
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.
-
Show who modified the value in a specified column
Background We create and approve purchase orders via Smartsheet. On receipt of the invoice to the accounts team the named approver (Contact List column) for the PO is sent an update request with the attached invoice and the field "invoice approved". They review and check the box, submitting the update. There are 12 invoice…
-
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…
-
Link two projects
Hi everyone, I have question that I have two different projects can I link them? Can I able to set Predecessor from one project to other? Thanks, Pranav
-
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…
-
Automatic email when column is "completed"
I am creating a "request sheet" for our company to use to request help in different areas. I used the web form to create the sheet and the user can get an email and those of us that are currently shared members can get an email, but I want to be able to have an automatic email sent to the "requester" when the row is…
-
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…
