I'm trying to create a calculated formula that sets the column with the value of the "Proyecto" text column if the column "Estado del Proyecto" is not "Finalizado", and if it is, with a blank space.

Do you see anything wrong with the formula?

=IF(NOT([Estado del Proyecto]="Finalizado"),Proyecto," ")

I have resolved it. I had to use a semicolon because of the regional settings.

  • If you got your solution, then please mark it as accepted answer, otherwise your question will be queued in Unanswered questions list.:) – Dikesh Gandhi Apr 21 '16 at 4:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.