-
Email from Rule
Hi everyone, I have a rule set up to send me an email whenever a row is added. I'm not sure why, but when the email comes through, the fields are highlighted in yellow. Is there a way that the information comes through without being highlighted? Is the rule correct? Attached are images of the email and the workflow. Thanks…
-
If Status is "Complete" Fill in #of Stores information into "# Stores Complete
Hello, I am looking for help writing a formula for: IF Status = Complete - pull value from # of Stores into #Stores Complete Column. Thanks, Molly Morton
-
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…
