IF formula with single select dropdown

09/16/20 Edited 09/16/20
Answered - Pending Review

I could use some help with the IF formula when trying to add a value to a single-select drop down.


I am using percentage to track a customers completion of our program. I have a column labeled "Sleep Study" with the drop down options of Required, Not Required, Complete - records requested, Complete - records received.


When the option "Required" is selected, I want it to subtract from the total percentage, so I assign it as a negative number using the IF formula. From what I've read on other's similar issues, I should be using the formula: =IF(Sleep Study = "Required", -0.1) but it comes back as Unparseable. I also tried =IF(Sleep Study = "Required"@row, -0.1) as some of our other formulas require the row, but that doesn't work either. I don't need any of the other drop down options to contribute to the percentage.


Thanks!

Answers

  • StefanStefan ✭✭✭

    Hi @Joelle Roehl,

    would you mind sharing (personal data removed) a screenshot?

    In your formula, there are a couple of syntax failures, but I'd like to know how the % of completion is tracked/entered/calculated?

    If you enter % in the column manually, you cannot use a formula in there because you would delete it once entering data. If you use a formula to generate the %, then the part for subtracting 10% for the sleep study should look like this:

    if([Sleep Study]@row = "Required", -0.1, )

    Column names in formulas need to be in brackets if they contain spaces or special characters, @row tells the formula where to look at (same row but column "Sleep Study") for a defined value.

    Hope this helps

    Stefan

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

Sign In or Register to comment.