-
Develop formula to break up project ranking figures into 4 quadrants
Hello! I have developed a format for my team to utilize a ranking process for incoming continuous improvement ideas. The methodology is called RICE Ranking which you may or may not have heard of. Within the ranking, we want the info to automatically designate which quadrant the idea falls into based on it's rank which…
-
COUNTIF Function Within Date Range
Hello, I am trying to write a COUNTIFS formula that would pull within a certain date range. Right now, the criteria would be to pull from a specific Project Reach and then an expiration between 1/1/2021 and 1/31/2021. The formula I have right now is not producing a count, so I'm doing something wrong: =COUNTIFS({S2G Master…
-
Can't seem to get vlookup to work
I have a master sheet and a secondary sheet. In the master sheet I put in all my data such as the “Name of the Project” and “Asset Type”. This master sheet is already pretty complex and has too many columns already. In the secondary sheet I want to keep track of a different set of data related to these projects but some of…
-
COUNTIFS with OR included
Good Afternoon, I've got a doozy of a formula that I just can't figure out. I've been on the phone with smartsheet and it is still not counting correctly. Here is what I need it to count: -Range 1=on or before 12/1/20 -Range 2: Consultant name listed in the row -Range 3: Blank OR (on or after 1/1/21) Here is the formula I…
-
How do I write a formula similar to a lookup in Excel?
I would like to populate a field in the Summary of a sheet with a contact name from another sheet. I am looking for help to write a formula that will say: Find the row where the words 'Project 25' is in a Column titled Project Name, in Sheet 'All Projects' and return the text in the column of the same row titled "Manager"…
-
#Invalid Operation when attempting to find difference between two cells
Good afternoon! I am trying to get the difference between two cells (both from formulas) but get the "Invalid Operation" instead. I know this is simple and I'm overlooking something!
-
Array formulas
Hi, I was looking for using array formula functionality in smart sheet. I need this because i saw that like this i can full fill what i need. Any case, could you please mention if is a way to use array or other solutions in order to perform: - I want smart sheet to show me in a column date, the first date, closest that…
-
Concatenate text and currency issue
I am trying to concatenate or JOIN a column with currency and standard text - I can do this, however it doesn't show zeros on the currency, for example; instead of £2.00 I get £2 Can anyone help as to how I can get the formula to exactly replicate the currency value. Obviously adding a zero to every result isn't an option…
-
How to calculate number of text occurrences in column and return a number
I am trying to calculate when a Y appears in a specific column and return the number 2 when this occurs and 0 when is N, any ideas on best formula have been pulling hair out!! Thanks
-
Having trouble using VLOOKUP formula in my Smartsheet
Hello Community, I have been trying to use VLOOKUP to cross check a screening date to what screening number was performed on that date, or within the date range; though I haven't been able to make it work! Please can you help me with what I need to do to make it work. My formula is: =VLOOKUP([Date of stock switchover]25,…