-
Column Formula for only Parent Rows
We have a few sheets that use different formulas for both Parent & Children rows. Is there currently anyway reference whether a row is a parent or a child row so that we can run different formulas in the same column while using the column formula functionality? Thank you!
-
Is there a way to create a search box?
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
-
Help pulling data from certain date range
I am currently pulling data from a mainsheet into a dashboard via a metrics sheet. Its working fine but I have been asked to start only showing data from the last 30 days on the dashboard. I am having problems figuring out how to add a date formula to my current formulas. An example of my current formula is…
-
=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"…