-
Formulas Not Autofilling With Form Submission
I'm having some issues with a formula that refuses to autofill with a form submission. The form is submitting new entries at the top of the sheet and I have two cells below it that contain the formula. According to this help article, it should be autofilling the formula into the new row. What has been driving me crazy was…
-
COUNTIFS HELP!
Hello, I'm attempting to write a formula that says count if this branch is rendered but not if this column shows "PTB"... I got the first part to work and it counts if the branch is in there but cannot get it to not count those with PTB in the PTB? column. if you need any further explanation please let me know! Logic:…
-
Will locking a parent row lock the children?
Hello, I am looking at creating a way to track monthly time sheets. Ideally, I would like to have parent rows for each month with numbered days beneath. In theory, I would like to have an option where the supervisor approves that month, and then it automatically locks the entire month. This would mean that it would need to…
-
Report | Date column showing time stamp in column title
Does anyone know why this is happening? I have many date columns in this sheet and for some reason this one (Store Closed Date) is showing 7:00 am?
-
Data entered in form not visible
I had a student enter client data into a form, but I do not see the data in the sheet. However, the summary sheet shows that there are far more records listed that visible in the sheet. There are no filters set, and no columns are hidden. Is there a reason that the data would not show on the grid? Thanks
-
One Dependency for the start, another for the end?
Hi... I'm trying to set up a project that has a task (weekly update reports) that begins with one dependency (e.g., start of project), and ends with another dependency (e.g., on-site work). There are still some administrative tasks that continue after the on-site work is done, but I won't have to continue the update…
-
Help with formula with RYG Balls and Start/End Dates
Hello, I am trying to clean up a program management smartsheet. I am wanting the status column (RYG balls) to communicate with the % complete column and the start and end date column. This is my current formula: =IF([% Complete]93 = 1, "Green", IF([% Complete]93 > 0.49, "Yellow", IF([% Complete]93 < 0.48, "Red"))) With…
-
Countifs Name reference
We are working on a formula where we are needing the counts of two names in a column. So if the range column we are pulling from has both John Doe and Jane-Marie Doe, we want the count of how many times that occurs. This is the formula we have and it is not working: =COUNTIFS([{A Great Place to Work Range 4}]:[{A Great…
-
Help with the Alt-Enter function
I have not been able to find the answer to this question in the forum. I have tried using the Alt-Enter to enter data on multiple lines in a cell. However, when I leave the cell, the data reverts to all being on the same line. It is not displayed on separate lines as I want it to be. What am I missing or doing wrong to…
-
Using COUNT and CHILDREN functions to return non-blank rows under parent row of a different sheet
Hi Smartsheet Community, I need a formula which will allow me to look up the number of non-blank rows under a parent row from another sheet and return the value. As an example I've attached a screenshot of my reference sheet where I am trying to count the non-blank rows under the parent row "Over 50%", some of the…