I created a list of date where my team members can meet. It is a lookup column.

Now I have to write a formula with this lookup column in a new column called formula1. For example "=NOT([Due Date]=0)". Meaning that if the column "Due Date" is empty, I will have a "No" in the column formula1.

After some research on the internet, a found that it wasn't possible to create a calculated column based on a lookup column.

Have you any idea how to skirt this limitation ?

  • Not, only simple column types can be used Commented Aug 10, 2016 at 7:46
  • Lookup columns cannot be used in Calculated formula
    – Gaurravs
    Commented Aug 10, 2016 at 8:09

1 Answer 1


Yes you cannot apply formula on look-up columns. But one workaround i could suggest is to use Javascript. Since the list is showed in a table form, you could change the text of every td of this specific tr to 'No' where ever there is an empty string. I hope it works for you.

  • Sorry, I didn't understand. What is td and tr ? I have the date in a table form based on a list.
    – Aran
    Commented Aug 10, 2016 at 11:27
  • See the list view web part is viewed in a tabular form, so it will obviously have tr(table rows) and td ( table data). Check on Google, HTML tables. You can use JavaScript to pick these td/tr accordingly. Google a little and you will get Javascript functions too. Let me know if you need more help.
    – mohd tahir
    Commented Aug 10, 2016 at 11:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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