-
Creating a flagging process
Hello, I have created a form to be fed into a mastersheet so that persons should submit twice weekly, 3 days apart. Because many persons will be submitting weekly, I would want the system to flag persons who havent submitted twice for the week. Grateful for any assistance to create such logic.
-
How to include an if statement
I have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x if it matches the name and version number.
-
Combining AND with HAS and WEEKNUMBER
Hello Again, My goal is to have a formula that will do the following: If the Lot ID@row is found on the {Lot ID} column on an Archive sheet AND The WEEKNUMBER(Move Date) where the Lot ID on the Archive sheet was found is equal to Week#@row THEN give me a value. If not then 0. =IF(AND(HAS({Lot ID- Archive}, [Lot ID]@row)),…
-
Assign a score for a GPA
I need a formula that says, IF GPA column less than 3.0 assign a 0, if it is 3.0 - 3.49 assign 2 pts, if it is 3.5 - 3.89 assign 3 pts and if 3.9 - 4.0 assign 4 pts The formula I'm using is, =IF(GPA@row, <3, 0, =IF(GPA@row, =3 - 3.49, 2, =IF(GPA@row, =3.5 - 3.89, 3, IF(GPA@row, =3.9 - 4, 4)))) Thanks for the help.
-
COUNTIF and CONTAIN Formula Help
Hello, I'm creating a view for the dashboard that counts the number of open risks, issues, and decisions from a project dealing with multiple platforms (A, B, C, D). I would love some assistance with correcting my formula. I'm referencing another sheet (Risk & Issue Log) that has the following range columns: Platform (A,…
-
I am wondering if I can chart revenue by month in the below example?
The chart is pulling from a cell that for instance is a $1M dollar project over multiple months however I can only figure out how to display the revenue in the 1 month. =SUMIFS({Pipeline Overview Data Range 2}, {Pipeline Overview Data Range 5}, >=[Start Date]19, {Pipeline Overview Data Range 5}, <[End Date]19, {Pipeline…
-
Sheet Summary AverageIF
Good morning, I'm hoping someone can help me with this AverageIF formula. I am trying to get an average between two columns but only if the location in another column meets certain criteria, this is what i have but i'm getting #UNPARSEABLE =AVERAGEIF (Location:Location, ="Bonita",[Total Graded]:[Total Graded] [# Titles…
-
Calculating Average Days between 2 columns
Hi All! I am making a report for a Risk Submission Sheet and I have two columns within my sheet: "Date Submitted" and "Date Closed." I want to create a widget for a report that calculates the average days it takes to close a risk from the "Date Submitted" to the "Date Closed" for ALL submissions. Knowing that 1) risks…
-
How to create children in large sheet automatically
Hi! I'm new to SmartSheet and not very good with Excel 😪. I have a sheet with over 18,000 rows that I would like to make any cell in the primary column with a date a parent of the rows beneath. I used an excel formula to find and add the date to the Primary column based on blank cells and a separate Event Date column (see…
-
Formula to return a blank cell if columns are blank
Hello, I am working on a formula that will return me the following: If equal to or less than 4 = Low If equal to or less than 7 = Modest If equal or less than 11 = Moderate If Greater than 12 = High =IFERROR(IF([Risk Score (calculated)]@row <= 4, "Low", IF([Risk Score (calculated)]@row <= 7, "Modest", IF([Risk Score…