-
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,…
-
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?
-
Combining these three formulas
Can someone help me combine these three formulas to result in one final Answer? =IF(AND([HP Advance Pull Print?]@row = "Yes", [Account Size]@row = "Small"), 56, 0) =IF(AND([HP Advance Pull Print?]@row = "Yes", [Account Size]@row = "Medium"), 112, 0) =IF(AND([HP Advance Pull Print?]@row = "Yes", [Account Size]@row =…
-
Formula Challenge Sheet
Hello! I remember I used to own a sheet called Smartsheet Formula Challenge (there are race cars visual in the sheet) that has few good scenarios/challenges on Formulas which I have been using as a reference! However, since I moved job, I dont have a copy of that anymore neither I know where to find them! Does anyone has…