-
Find the Percentage of the Total
Hi! I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, I…
-
Nested IF/AND Formula
I'm receiving an #UNPARSABLE error for the following formula: =IF(AND([Completion Status]@row="Completed", [Actual End Date]@row<=TODAY()), "1", IF(AND([Completion Status]@row="In Progress", [Actual End Date]@row> TODAY()), "2", IF(AND([Completion Status]@row="Not Started", [Actual End Date]@row> TODAY ()), "3", "4")))…
-
Health Status Formula dependent on due date
I am experiencing trouble trying to write a formula for the below situation. See above screenshot as reference. Can someone please advise on how to write this formula correctly? This is the current formula I'm using, but I know it's not correct: =IF[On Hold] = 1, "Gray", IF([Due Date]@row >= TODAY(15), "Green", IF(AND([Due…
-
CountIFS and Summery Date Field
Having trouble with the following formula returning an "Unparseable" error. =COUNTIFS(Type:Type, "Release", Status:Status, "Complete", Due Date:Due Date, >=[Current Quarter Start]#, Due Date:Due Date, <=[Current Quarter End]#) Can anyone provide some help?
-
COUNTIF and COLLECT
If the column "Graduation Year" is "2021", I want to collect from the column "Position TYPE Post GME Training" the total number of cells with "Private Clinical Practice-local". See below. What am I doing wrong?🤔 There are multiple values in addition to "Private Clinical Practice-local" in the dropdown for "Position TYPE…
-
Using SUMIFS with YEAR and MONTH from single referenced column
Hi all, I'm trying to create sheet that will sum up all revenue for a year, by month. End result should look something like this: I'm using this formula and receiving an #INCORRECT ARGUMENT SET error: =SUMIFS({anrev}, {vehicl}, "Site", {Scale Date}, IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 1) (this is for…
-
Use only parent rows in a referenced sheet
I'm trying to count the number of times a text string is found in a different sheet in columns of the same name, but I only want to count if the name is in a parent row of the referenced sheet. The formula below is #unparseable. What is wrong with it? =COUNTIF({Sheet1 Names}, CONTAINS(Names@row, @cell), {Sheet1 Names},…
-
Match Cell Content in New (Form Provided) Rows with Content in Previous Rows
Hello I am looking to use a formula to bring an entry from an existing cell into a new row when another column in that row matches. I will be deploying a Smartsheet webform, and when the last name of a respondent matches in a new response, I want that new row to automatically contain the Dropbox folder for recorded in the…
-
IF AND statement with TODAY function
I am trying to write a formula where if the date in the "Date" column is greater than or equal to today AND the "Attended" column checkbox is not checked, then check the box in the "Missed" column box so that a notification will go out to all of those who missed the training. This is what I have that is giving me an…
-
IFERROR MONTH
#UNPARSEABLE error when adding the MONTH function. =COUNTIFS({Incoming Quality 1}, Quality@row, {Intake Sheet Range 1}, IFERROR(MONTH(@cell),0) = 4))