-
=ROUND(SUMIF
Hi =ROUND(SUMIF($[Pareto Category]$32:$[Pareto Category]558, Predecessors21, $[Actual (MHrs)]$32:$[Actual (MHrs)]558), 0) The above is my formula. It says, "IF the value in the Pareto Category column is the same as the value in the cell Predecessors21, then count all of the values in the Actual (MHrs) column". However, I…
-
Sumifs with a condition on multi select column
Can anyone help me to write a formula of Sumifs. I am facing issue since in week column i have multiple select property used. I want to sum the time required if member X worked on week 1. Similarly time required for member x wherever week 5 is mentioned.
-
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…