-
If Formula not reading blank correctly
Hi, Any chance you can help me figure out why my formula is not working and assist in fixing it. The formula right below is the one I am trying to get to work and I am wondering if there is a way for the Purple box that says complete to say "not started" since it clearly has not been started. =IF(COUNTIF(Status78:Status82,…
-
IF AND Formula to auto populate a checkbox
Hello, I am creating a report that references another sheet. I would like to know if a person from a certain organization attended a training. The formula looks at 2 different columns from the other sheet. One of the columns has the name of the organization, the other column indicates if they were in attendance. In my…
-
Change date every week
I have a sheet and I want resources to provide their status update every week. A request to update is sent every Friday. I want the "Current Week Ending" to be the Friday of the current week. Resources can enter their update for that week starting the Wednesday before till the Tuesday after. Every Wednesday, I want the…
-
COUNTIF/S Formula?
Hi All! Needing some help with the below query, the outcome is extremely straightforward but I feel my immaturity with SmartSheet is causing some blockers. Question at hand: I currently require the formula COUNTIF/S to count multiple criteria within a row but I can only seem to get it to work for one. For example I need to…
-
Omit records with No data on Charts
I have a Workspace with a form that feeds into a sheet Then I have a calculations sheet that adds up everything (most of which us SUMIF). Now a few of these Workstreams (which are in a dropdown list on my form/main sheet do NOT have any data currently associated with them. But that will change. And like I said these…
-
How would I use an Index/Collect formula to include Child Row data as one of my criterion?
For example, I would like to collect a certain column based on a specific text string in another column, however that text string is located in a child cell/row which I believe is the reason I am receiving an "Invalid Value" error. I have two separate criterion in my formula, and I removed this text string portion to…
-
Is there a way to get todays date?
Hello I don't think this is possible but i was just wondering if there is a formula or way that i could use to pull today's date and have it auto populate the cell once the form is submitted. Currently I have it set up so in the form they fill out they just enter today date but i didn't know if there would be a way to…
-
At Risk triggered by formula
Hello!! I'm trying to target the "At Risk" column with a formula to "flag" automatically. I need to have my At Risk flag marked automatically if a task is overdue [End Date] and the [Status] is "Not Started" and "In Progress" I tried using this formula: =IF(AND([End Date]@row <= TODAY(), Status@row <> "Not Started" "In…
-
Formula for RYGB Symbols using % Complete AND Due Date
Hello all, I'm trying to create a formula in the "Health" column that will display RYGB symbols to indicate the following: Blue = 100% (Complete) Green = greater than 50% (In Progress) Yellow = less than 25% (At Risk) Red = 0% (Delayed) I am to use the "% Complete" column AND "Actual Due Date" column to determine what the…
-
Locating the parent of a parent
I am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent is what I have imagined would work, but =parent(PARENT([Task Name]@row)) is…
