-
Update formula so it ignores empty rows
Hello. I am using the below formula to mark whether a task is overdue or not, and then highlight using conditional formatting those overdue tasks in red: =IF(AND(Finish@row < TODAY(), Status@row <> "Complete"), "true", "false") I would like to update the formula to ignore blank rows. How may I accomplish this? Also, open…
-
IF(Contains . . . not returning value I'm actually looking for
I have the following 'IF(CONTAINS . . . formula which is returning '#UNPARSEABLE'. What I need is the Names of individuals where #0136 appears in a column on another worksheet. I don't really know if this is the correct formula to be using for the action I'm wanting. Thoughts?
-
Formula to calculate total lost
Hello and good morning. If someone would not mind providing the correct formula for what I'm trying to accomplish, I would be very grateful. Thank you in advance for any help you would be willing to provide. I have three columns, Sales stage, Forecast Amount & Total Lost. I need a formula that will reference the Sales…
-
Formula for quarter based on finish date
I want to create a formula that will auto-populate the Quarter column with Q1, Q2, Q3, or Q4 based on the date entered in the "Finish Date" column. For instance, if the "Finish Date" is 4/15/2021, I want the Quarter to be "Q2".
-
Parent/Child Formula for Levels
I am trying to create a parent child formula to deliver numbered levels. The formula I have so far is working for a couple of levels but not 4-5 levels deep (see example). I've worked on this and have now confused myself so needing a bit of helping getting out of my own 'circular reference'…
-
Within X amount of time from Today
Hello, I am trying to find a formula that will tell me if a date is within 4 Years of today's date and populate "YES" or "NO" in a separate column. (Example: To help specify if a product is in warranty that lasts 4 years, and populate "Yes" in another column if the date entered is within 4 years)
-
If blank OR value, then
Hello everyone, I am new at creating formulas and can't seem to get this right. I've tried so many ways and I am officially confused. I can get it to work with one criteria but not two. If value in [Document Status] is blank OR <> "draft then uncheck box if any other value, check box Here's one of the formulas I tried…
-
Returning a value based on duplicates in two columns
I'm trying to create a formula that will return a value if criteria from two different columns are duplicates within their own columns. It would look at Column A and look for duplicates. If it finds a duplicate, it then looks at Column B to see if the rows that meet that criteria have a duplicate. If it finds a duplicate,…
-
Formulas
In Excel, when you create a formula, you drag it down so it is the rows below. In Smartsheet, I don't think that is the best practice. How do make sure the formula will be used, but that I don't need to drag it down like in Excel?
-
Sheet summary formula to add number of attendees based on a program type?
I am trying to count number of attendees (one column) based on a different column (program type) we have running ("A" vs "B" vs "C"). I am getting unparseable. Any suggestions? I am trying to use the below formula: =COUNTIF((Program:Program, "A")) (AND(=COUNTIF(Number of Attendees:Number of Attendees, >0) I have also…