I was wondering if someone can assist with the following.
I’m trying to create an “If” formula for my “Previous Job #” column
Depending on the “Type” I will be either a “capital” or “service”
If service then the value is “Not applicable” and if Capital then I have an ID number to enter
I understand the first portion, but I don’t get how to get it to let me enter my own values if it’s not a “service”
IF(Type = “Service”, “Not Applicable”)