Formulas

We’re using a sheet for ticket tracking. Issues come in via a form, manual entry, or the Gmail Add-on. We’re using hierarchies to track To Dos as tasks. I use a simple formula to tell me if a row is a task or a parent. =COUNT(ANCESTORS()) I use the value for formatting and for accurate issue counts as I only want to count…

The following works for my sheet but I'm unsure how to write it so that if there are no child rows, it will say "No Submission Received". =IF(COUNTIF(CHILDREN(), OR(@cell = "Facilities Readiness", @cell = "Workspace Navigation and Signage")) = 2, "Final Approved", "Partially Approved") Appreciate any assistance! Thanks!

Hello, I'm trying to create a formula to count the number of instances of a particular date - but I can't get a response out of the forumla - it either comes back as unparseable, or with a 0 count (even though that's the wrong count). I've tried a few variations: =COUNTIF(DATE:DATE,06/10/2020)…

I keep getting an "#unparseable" on what I think is a simple IF statement. Can someone help me out? Here's the statement ---> =IF([Coffee Chat Completed]1 = 0, "Yes, Follow-up Needed", ["No, Follow-up Not Needed"]) It's Monday and I think I need more coffee. Thanks, Smartsheet Community!

See picture. I`m trying to find the formula too help me sort out the average productivity in different productionlines. Can somebody help me with the right formula? I need to find the averiage "produktivitet" sorted by "Linje 1, 2 etc" and sorted by date. Referenced from the sheet below to another sheet.. :)

Hi, I am trying to return a RED value (traffic light) to a specific cell where any cell in the column "Risk Flag" has been checked. I can get it to return a Red value where a single specified cell in the Risk Flag column is flagged - as follows: =IF([Risk Flag]2 = "True", "Red") I need it to return a Red value where any…

Hi Within my project plan sheets I have 2 columns , On Time/Late and RAG. On Time / Late Column Formula =IFERROR(IF(AND([Original vs Current (days diff)]@row > 8, Status@row = "Complete", Milestones@row = "true"), "Late", IF(AND([Original vs Current (days diff)]@row <= 7, Status@row = "Complete", Milestones@row = "true"),…

Hi All, =COUNTIFS([Execution Team]:[Execution Team], "NA ISG Specialty Event - AH Org", [Start Date]:[Start Date], DATE(2020, 8, 1) <= DATE(2020, 10, 31)) I am using this formula to gather number of events we're having internally. I did this per QTR and change dates, but noticed that it is counting ALL events that are less…

The following formula works for counting my check boxes but I cannot seem to figure out how to write the rest of the formula to only count the check boxes in my row if "Yes" is written in a cell in the same row. Help please! =COUNTIF([Building Perimeter Verified]@row:[Reminder Email Sent]@row, =1) Thanks so much!

Hello, im trying to generate a formula on what is checked the previous and next week but not the current week. im trying this but with no luck: =IF(WEEKNUMBER(Date@row) < WEEKNUMBER(TODAY()), WEEKNUMBER(Date@row) > WEEKNUMBER(TODAY()), 1) Can you help me?