Hi all!
This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I have tried to come up with he formula myself but when I input it, I receive and error "This column is restricted to dropdown values. Please let me know if there is a solution to this or if I have done this incorrectly. Thank you in advance!
This is the formula I tried:
IF(ISBLANK(@cell), "0%")
Best regards,
Muhammad
IF(ISBLANK(@cell), "0%")