-
What function can recognize a name in a multidrop down list and reference a corresponding column?
I am trying to create a sheet with the purpose of allowing a supervisor to see what crew members are currently busy and what days. This is Sheet B, while Sheet A is the list of projects and all corresponding details, like dates and crew members. I am doing this with an "Status" column in Sheet B, which scans the crews ofβ¦
-
COUNTIF Formula Only Works on Certain Rows
Hey Smartsheet Community, I am currently being stumped by this formula that for some reason only works in a few rows. It is a COUNTIF formula that is counting the number of assignments each person has. I will paste it below: =COUNTIFS({Resource Name}, FIND([Qarbon Owner]@row, @cell) > 0) I have 29 people that I need toβ¦
-
Overtyping a formulas answer
I need to automatically calculate a number in one column based on another column, but also need the ability to overrule this result at times and manually enter an answer in the "calculated" column. When I do I don't want to change the column formula to a line formula as multiple lines are continually being added and thingsβ¦
-
Calculate Time Difference (24hour w/o :)
How can I calculate difference in time when it is entered in 24 hours with no colons?
-
Contains feature
I need assistance with a formula. In my master sheet, I have a Contact column, where the formula lives. Here is the formula I have at the moment, which does work as it takes the value of the Workstream column over to a secondary sheet where I match the Workstream in order to get the appropriate Contact.β¦
-
Nested IF(AND) ISBLANK all together?
I'm writing a formula to return priority timing based on days left until end date. Here's what I have. =IF(AND((IF(ISBLANK([Working Days Left END DATE]@row)), "NEW"), IF(AND([Working Days Left END DATE]@row <= 3, [Working Days Left END DATE]@row > 0), "URGENT(0-3 days)", IF(AND([Working Days Left END DATE]@row > 3,β¦
-
Return value based on a MAX date and other criteria
Me again Is it possible to create a summary report that shows the individual rows of data based on the latest date (Date of Completion) and other columns so as to only show 1 row per location (multiple locations can occur in a single building) - See example image below The items in green have the latest dates against theirβ¦
-
Decision formula
I have created the nested if formula to show the "RED, GREEN, YELLOW" status, but it will not convert to the actual symbols. It just reads red, green or yellow. Any suggestions on how to address it? =IF([% Complete]@row >= 1, "GREEN", IF([% Complete]@row >= 0.5, "YELLOW", IF([% Complete]@row < 0.5, "RED")))
-
I am having an issue with Count(Distinct(Collect returning 1
The formula doesn't error out but produces a 1: =COUNT(DISTINCT(COLLECT({Server}, {Installation_Date}, YEAR(@cell) = YEAR(TODAY() - 3), {Installed_Date}, MONTH(@cell) = 7))) I have a list of servers, the hotfixes, and the date the hotfixes were installed. So 1 server may have multiple hotfixes applied during a month/year.β¦
-
I'm trying to grab name from a row on a separate sheet where the row matches two criteria.
I'm trying to grab a name from a row on a separate sheet where the row contains "Completed" and the same part number. Here is the equation I'm attempting to use but get "UNPARSEABLE" =INDEX({Employee Name Column}, COLLECT({Employee Name Column}, {Part Number Column}, [Part Number]@row, {Part Complete? Column},β¦