-
Is it possible to count a Blank Cell only text is filled out in another cell?
Currently I'm using this formulaΒ =COUNTIF(Status:Status, "") to summarize all the blank cells in the Status column. The issue is that it also counts the Status cells that are just blank rows at the bottom of the sheet. Is there a way to count only the blank Status cells if there is also information populated in theβ¦
-
Invalid date causing error in Formula
I have formulas written based on a date but some of the dates in my sheet contains blanks or text. So in my formula, it is giving me an Invalid Data Type error. Is there a way to determine if the date is valid date in the formula? I can check for blank, but dont know how to check for anything else. Can you use ISDATE inβ¦
-
Formula Query
I'm at a loss for how to perform a desired calculation within a sheet. I have a list of rows that are assigned to owners (contacts). Each row has a % complete. I want a formula that will tell me what a given contacts overall completion rate is. * Look up name in Owner column * Add up all percentages in the "% Complete"β¦
-
Formula not refreshing when date changes - Can't tell I'm connected?
Hello ~ I'm new to Smartsheet and would appreciate some assistance. I have a formula that changes the color priority as the next action due approaches or passes, reflecting if the task is pending action from others: Rows that are marked "Done" then gets conditionally formatted to Grey (this was a workaround to not having 5β¦
-
Formula assistance:
Hello, I am looking for some assistance with how to write a formula that will auto-fill a check box. I only want this checked if the Parent Cell column is blank and that the Assigned to is equal to the user. Currently, the formula I use auto-checks is the Assigned To contains the user's name. Any advice on how to modifyβ¦
-
Years in Service Formula
Good Day, We are struggling with getting a "Years in service" calculator to work, after having pulled all the formulas that could be found by previous posts, still no luck. =IF(AND(MONTH([Start Date]1) >= MONTH(TODAY()), DAY([Start Date]1) > DAY(TODAY())), YEAR(TODAY()) - 1 - YEAR([Start Date]1), YEAR(TODAY()) -β¦
-
Macro Functionality
Hi, I am using SS to track projects. At the top of my SS I have a master list of tasks with sub tasks. I expand all this out to copy the whole lot and paste them back in at the bottom for my next project. SS does not allow you to simply copy the unexpanded parent row and copy all child rows. My question here is as follows.β¦
-
Nested If Statement - help needed
I'm trying to get this formula to work. =IF([PRO Number]9 - [Trailer #]9 > 10), " PRO Levels: OK", IF([PRO Number]9 = [Trailer #]9, "Yusen Needs PRO#s"))) I want to trigger the IF/Then statement if the value of ([PRO Number]9 - [Trailer#]9) is equal to orΒ less than 10. See screen shot below.Β
-
IF/AND Formula
I am trying to create a formula for when two approval columns have 'Approved' in their dropdowns to change two other dropdown columns. When "APPROVAL Status - BOB" = "BOB - APPROVED" AND When "APPROVAL Status - JOEL" = "JOEL - APPROVED" THEN "Approved?" column will change to "Approved" AND "Issue Status" column will changeβ¦
-
Formula help - adding criteria to LARGE?
Seeking some advice on how to make the LARGE function play nice with criteria and possibly, I'm thinking, the COLLECT function. Here's our set up: "Master project sheet" with: 1) "Project name" column 2) "2019 total hours" column which is a cross-sheet reference SUMIFS formula 3) "Project priority score" column which is aβ¦