-
How to use a formulas to indicate current constellation in sheet summary
Hi guys, I have a sheet to indicates constellations by date, and I cannot find a formula to get current constellation based on today's date, can anyone help with this? Much appreciate!
-
IF Formulas including Blanks and AND / OR
Hi I'm looking for a formula that will show me whether a deadline has been met. My Deadline Met formula is currently only taking into account the Agreed Deadline Date and the Date Completed =IF([Date Complete]@row <= [Agreed Deadline]@row, "Yes", "No") However, what I really need it to do is also check if a). There is a…
-
IF(AND Formula + substraction
Hello! I have the % Burn Rate of my project and the % Complete, I want to subtract and according to the difference in them I want Harvey Balls to display different colors. If the difference between the % Burn Rate and the % Complete is => 6% I want it to be "Red" If the difference is From 1% to 5% I want to be "Yellow" And…
-
Duplicate Entry Formula for Data Across Multiple Columns
Hi, I'm hoping someone can share the correct formula to indicate a Duplicate entry where all multiple columns all have to be 'true' for the indicator to show a duplicate row/entry. Example: To trigger the "DUPLICATE ENTRY' status, I want to make sure SITE, BLDG, ROOM, and DESCRIPTION/CATEGORY all have the same value, not…
-
Update on Formula Errors with Range References
We're investigating reports from a small number of customers who are reporting issues with cells containing a formula with a range reference. The issue is that the cell value flips between the correct calculated value and some formula error, such as #BLOCKED, #REF, etc. This behavior occurs when a Smartsheet internal…
-
#blocked Formula
I have a sheet that used to be operationnal, and sudenly, I get "#BLOCKED" on some of my formula. I know that the formula should be ok because I have the exact same formula in similar pages. In fact, the formula is a nice addition to the GANTT view. It list all the predecessor task by taskname. I have another one for all…
-
Removing ' from cells
Hello, I imported an Excel spreadsheet containing a column of identification numbers that are 6 digits in length. When I tried to set up an index/match formula using the values in that column, I got a "no match" error. After a little research, I discovered there is a single quote at the beginning of each ID number. I've…
-
Need help with an IF Statements with multiple ORs and an AND
Hi. I need to write an IF statement where if the Review column has one of the following: Review Complete, Reviewed - Not applicable, Do not include, Reviewed - Not applicable, send feedback AND the COMM Review column has the following: COMM Review Complete If both the Review Column has one of the 3 options AND the COMM…
-
Index, Match, Collect and/or Vlookup?
Hello, may I get assistance with a formula? Thank you. Sheet 1 ---> data in columns: Course Code, Section, Instructor Sheet 2 ---> column names: Course Code, Section, Instructor (blank) In sheet 2, I want to pull the instructor information from Sheet 1 based on course code and section in sheet 2. Here's what I have but…
-
Check count by project type AND how many started that month
Hi, I'm trying to run a formula that would count how many projects were completed in a specific month and the column named "Tier" had the value of "Tier 3" but I can't seem to adapt the below successfully to include both conditions i.e. number of tier 3s completed in Jan =COUNTIF([Actual End Date]23:[Actual End Date]81,…
