Formulas
Discussion List
- I have a field called Status & a field call Health (using RYG symbols) This =COUNTIF(Health:Health,"Green") counts the symbols correctly. But I am trying to count Status "Open" that have a Health "Gre…
- Hello Community… Stuck trying to work out a COUNTIFS formula for Status is X and Year from a date column is current year, The first part I have… =COUNTIFS({Status}, "Pending Submission", The second pa…
- I need to do an index/match formula within the same sheet, but it is returning a UNPARSEABLE error. The columns in the sheet are as seen below: We're listing the parent unique ID and we want to find t…
- So, August 2024 has 22 Net Work Days. But as of today (08/07/2024), there are only 18 Net Work Days remaining in August. Is there a formula I can create that will show me "X Month's/X Year's" remainin…
- Hello! I have a sheet that is linked to a Jira project, and for Bug tickets, I'd like to see the titles of the blocked issues. Typically, I would use an INDEX/MATCH formula, but I'm not sure of the be…
- Hi all, I'm trying to to capture the name of the person who does the final change in a material release in a process. Please see attached. The goal is to have the name of the person who clicks release…
- For my projects (one per "column"), I have a column for "Deadline", "Remaining Hours", and "Networking Days Between Today and Deadline". Then there are columns that need formulas that need to calculat…
- This formula worked yesterday in my sheet summary field and today is not working.. =SUMIFS([Remaining Work]:[Remaining Work], Category:Category, OR(@cell = "FC Support", @cell = "Maintenance & Reliabi…
- Hello - I have a Parent Row that is an Item (Hardware & Tools) and children rows that have specific departments associated with each hardware/tool listed. Is there a way the parent row will automatica…
- Hi all! I am trying to set a IF forumula for symbols changing colors driven by multiple columns. =IF([BYT RELEASE DATE]@row = 0, "Red", IF([BYT ORDERED]@row = 1, "Yellow", IF([OPEN ISSUES]@row = 1, "B…