Hello, I am trying to sum hours noted in the children of a row (Total Hours per Project) if the current month is noted in another cell (Week Ending With). Here is what I have: =SUMIFS(CHILDREN([Total …
This might be simple for one of you but it's driving me crazy. Please help. The enclosed pic is part of a simple employee schedule where employee daily hours are entered on a "time in" and "time out" …
I am looking for some help on this one. I need to be able to find duplicates but only under specific conditions. For example, I have a list of SKUs as one column, and a second of the order status of t…
These formulas work independently. I am attempting to combine them into one nested if formula. 1) if the %complete is full, status is green: =IF([% Complete]10 = "Full", "Green" , "Red") 2) if the fin…
I updated our smartsheet team schedule to grab dates from my department's master schedule. However, the conditional formatting we set up that visually shows us when a project is nearing or past its du…
How do you structure your formula calculate negative if it is over 100% For example, I am at 144% which is over budget Current Formula =AC1 / [Project Budget]1 Results 144%, I would like it to calcula…
Hello All, I need help!!! I am trying to write a formula that replaces the letter "a" with the number "1", "b" with "2", "c" with "3", etc.... The individual formula of (ex.) =SUBSTITUTE([Column3]1, "…
I am using this formula to count for unique values within a range of cell. I want to be able to use a criteria, a date for the range of cell, what should the formula look like? =SUM((IF(FREQUENCY(MATC…
Hi all, Please need help on formula. The example image below is a project with sub tasks and I wanted to create a formula in the Progress column highlighted in yellow (this is the main header). The co…
