-
Formula to Change Harvey Ball Color Based off of a Word
I've seen so many examples of "Nesting IF" formulas for changing a Harvey Ball to a different color based off of multiple numeric or date scenarios. What I haven't come across is a way to change the ball color based off of verbiage: Example: I change a cell to Rejectedย and the ball turns Red. I change the same cell toโฆ
-
finding items past due
This is a formula to find out how many tasks Jane Doe hasn't marked complete in the last 7 days. It's not producing the correct number when I run it by a filter on the original dataset. Any insights on how to make it more simplified? COUNTIFS({Project List Range 3}, FIND("Jane Doe", @cell) > 0, {Project List Range 4},โฆ
-
CountIFs Formula Help to Show Number of Resource Open, Closed and Overdue Tasks Across Multiple Acti
I need a COUNTIFS formula (I think this is the best option based on research) that calculates all of my technical resources task status for all of the projects. An example is below. I have 4 current projects and 7 resources. Please see the screenshot for an idea of what I'm trying to accomplish on a Metrics sheet thatโฆ
-
Convert date format to "YYYY.MM.DD" in formula that combines date and text
Is there a way to do something like the excel formula =TEXT(TODAY(),"YYYY.MM.DD") in SmartSheet to allowย a specific date format to appearย in the output of a formula, regardless of the user's regional settings? All of our date columns have been set to the YYYY.MM.DD format, but we have formula columnsย that combine datesโฆ
-
Update a cell in a column with data from a different columns
Hi, I'm trying to select a range for the completion status and also trying to refer to a different column and get the data updated in a different column. I'm sure I'm doing something wrong here. Please help me! =IF(COUNTIF([Completion Status]3:[Completion Status]38, 0) > 0.5, "Not Completed", "Pending Mgmt Approval",โฆ
-
count one column based on a different filtered column
Hello, Iย have a list of staff names in one column and another column with task statuses (Not Started, In Progress, Complete). I'd like to find how many In Progress and Not Startedย tasks each staff member has. I've tried COUNTIF and COUNTIFS but can't quite get the formula right. All of the examples I'm finding are lookingโฆ
-
SUMIFS & FIND functionality with Summary Sheets
Hi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are "Cost Savings" or "Risk Management". I am also trying to create a formula for justโฆ
-
Counting Checkboxes for Children
Getting an unparseable error when i do this: =COUNTIFS(DESCENDANTS([Final and Locked]824, 1)) Basically, I just want it to automatically count the number of checkboxes in the next column so when new children are added by other users, I don't need to worry if the formula is capturing the new rows.
-
RYG symbols return date in different column
Okay so I'm almost done with my project but I ran into a snag and needed some advice. Basically what I'm trying to do is that when I pick the Green symbol todays date is input into the date column, Yellow = todays date in MISC column and leaves the previous date in the Date column.ย I'veย programmed for the green but everyโฆ
-
help with formula
Hello, I'm still quite new with sheets and I wonder someone can help me out with this formula I'm currently struggling with. What I want to do is to check/compare email addresses. The following works well when adding formula to a check-box type cell comparing whether the [Modified by] entryย is the same like [Email] entry.โฆ