-
Nested IF AND formula
Using the formula below to determine the health of a project but I need to change it. Right now it is showing the health as yellow if STATUS is Not Started and there are more than 14 days between now and the forecasted end date. I would like for it to show yellow when the STATUS is Not Started and there are 0-14 days…
-
Show Red Ball if Past Due
I have a formula in the "Health" column of a sheet. This formula shows a colored ball depending on the "Status" of another column. The "Status" column is determined by another column, "% Complete". Ultimately, the part of these formulas not working is that I want it to be a Red Ball if the End Date is past and it has not…
-
How to indicate the Top5 from a smartsheet with Case-insensitive criteria?
Hello! This is my second question here. The community was incredibly helpful for the first one! :) - I want to pull the Top 5 Customers with more active projects from a project tracker (the user inputs project ID and from a data pool, the Customer Name and other info are pulled) to a dashboard chart. So far, I am using a…
-
Why can't I have a formula in %% complete when dependencies are enabled?
I just spent a very long time figuring out how to make the %% complete column auto populate based on the dates. I was proud of my work until I had to 'enable dependencies' so that I could have predecessors. Surely it cannot be that uncommon for people to need both. My investors get reports where the 100% complete column is…
-
IF Statement involving columns in two separate sheets, with a return response from a date column
I'm stumped. I have a request to create a formula matching a Vendor ID in the current sheet to the same column in another sheet and if found, return a date from the GL Policy Expiration (second screen shot), which is Range 3 in the first screenshot below. I am getting a #Invalid Operation result. What am I doing…
-
Using an "ISBLANK" formula
Hi, I'm trying to populate Column C with the contents of Column A. If Column A is blank, I want to populate Column C with Column B. I've tried several formulas but cannot make it work. This is the last thing I tried: Thanks for any help you can provide!
-
IF Statements to JOIN or Concatenate cell values from 1 sheet into another
Hi, Needing some help to figure out the best way of setting up some automation.... I have a worksheet "Automated Assistant - Calling Mode". I have a bunch of workflows created to select certain items (tasks) in a multi select column "Next Action" column... See screen shot "Calling Mode sheet to show results." So right now,…
-
HELP: Formula for Dashboard
Hello, I've currently built a form that allows people to Check-In and Check-Out, which then they'll have a drop-down and select their name. I've also built an automated dashboard which will indicate how many people are currently checked IN in each area. Some of our staff forget to Check-Out when leaving work. How can I…
-
Weeknumber formula help? Need to calculate the number of times a tasks is completed per week
Hi Team, I have a sheet dealing with people being onboarded. I am trying to count the number of people that "Completed" their onboardings per week. Meaning week 2 in the given year, three people were onboarded. Not sure what the best approach is for this. I would think to create a cross-sheet reference to the sheet above.…
-
Creating a percentage average from yes /no cells
Hi I'm trying to use COUNTIF to create a percentage average driven from columns where yes/no/NA are entered can someone help?
