-
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!
-
Iferror query
Hi, I was getting a divide by zero error on certain fields so introduced the following into a calculated cell... =IFERROR(([Outstanding CCTV validation?]@row / [CCTV Validation Total]@row) * 100, "No data to allow calculation") At first I thought it was ok but when I get 1/1 for each cell - Outstanding CCTV validation? and…
-
Count if with due date in next #days
Hello from the North, I am having some trouble. I am trying to count if status is 'released'; and next review date is within 30 days. The formula I am using is bringing back info (49 counts); however, when I go to the sheet and filter with the same criteria, I get '1' count only (which appears to be accurate). Why the…
-
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…
-
CountIf with Or and And?
Hi All! I was hoping for some guidance on formula set up. I'm trying to create a chart of software defects and their severity. I have built a tracking spreadsheet for these items. I would like to count if the issue status is Submitted, In Progress OR Released AND the severity is Critical. I can then replicate this formula…
-
=COUNTIF - Columns "A" & "B" Has "1" & "2" Values
Hi, How Can I count how many of the column "User" is "Jack" and the Column "Daily Email" is "Done"? I want to make 1 calculation for both, how many users have these values. I treid doing the following: (It didn't work..) =COUNTIF(User:User, "Jack" + [Daily Email]:[Daily Email] "Done") Thank you!
-
Formula issue with B, R, Y, G Traffic Light with a Deadline and % Complete
I have been struggle with this formula to leverage the Blue, Red, Yellow Green harvey ball. Basically, If there is no deadline and the task has not been started then it should be Blue, otherwise if < current date and % Complete is not 100% then it should be RED, and YELLOW if the deadline is today and % complete is < 1 and…
-
Workflow notifications stopped on only ONE of my Smartsheets! Help
I have verified that the workflow has not changed (as these notifications previously worked fine) and I have verified that my settings are set to 'unrestricted'. I am receiving notifications from many other smartsheets, just not this ONE smartsheet. I have verified email address. Disabled and re-enabled. Created all new.…
-
=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…
-
Can I derive a name from an email address?
I have a sheet that has a person's name as my primary column and their email address in a contact list column. I have them filling out a form with both pieces of information and people would really only enter one or the other. I need the email address to send notifications and I need the name so they look nice on the…
