1

What is wrong with the formula I used:

=if([van]>=[today];"[Title]";"")

Where, [van] is a date/time field in a calendar.

[Title] is a single line of text.

Any help will be appreciated.

Ganesh Sanap - MVP
  • 44,918
  • 21
  • 30
  • 61
Daniël DENON
  • 11
  • 3

3 Answers3

1

The [Today] is not supported in the Calculated Column. however, to get the current date you can use:

  • TODAY(), NOW() as a function that will be returned as DateTime.

For more details check, The Supported and Unsupported Columns In SharePoint Calculated Column Formula

Mohamed El-Qassas MVP
  • 45,382
  • 9
  • 53
  • 96
0

You can't reference Today in SharePoint's Calculated columns without a workaround. Essentially you have to make a column named "Today" in your list, reference it in your calculated column, then delete the "Today" column to trick SharePoint into referencing the current date. Check out this answer for a better explanation.

If that doesn't work, and assuming the correct syntax for your SharePoint version is a semicolon rather than a comma like mine is, the quotations around [Title] may not be necessary. So try =if([van]>=[today];[Title];"") after making the dummy "Today" column.

Once you get the calculated column not error out, then delete the "Today" column and the calculations should work fine.

EDIT ::Please note that adding the [Today] field this way does not work as you may expect... The value is updated when you modify the list item. It does not compare to todays actual date, but rather the date of the last time the list item was modified in some way.

KGlasier
  • 1,745
  • 1
  • 10
  • 22
0

You cannot use [TODAY] directly in calculated formula. But there are some work arounds to use today in calculated formula.

Once you are done with using one of the workaround for using today. Use below formula:

=IF([van]>=[Today], [Title], " ")

Note:

  1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,).

    For detailed information and references check my answer given in below link:

    IF statement with text field isn't possible?

Ganesh Sanap - MVP
  • 44,918
  • 21
  • 30
  • 61
  • He may actually use semi-colon separated functions. Some versions of SharePoint, depending on where you are in the world, have different syntax. Also note that the Today column doesn't stay current. It's only updated when the document or list item has been modified in some way. – KGlasier Nov 01 '18 at 17:16
  • I always use comma in IF condition, see link. Also today is not a column, he need to use one of the workaround for today as given in work around link in my answer. – Ganesh Sanap - MVP Nov 01 '18 at 17:24
  • If you're using the danish regional setting, according to This answer then you need to use semicolons instead of commas since the comma is a decimal separator. I assume there's other languages that have the same style of formatting as the danish, so don't rule out other language syntaxes. And correct, the Today does need a work around but SharePoint won't update it all the time. The values in Calculated columns are re-calculated when the item is modified. – KGlasier Nov 01 '18 at 17:33
  • have you tried this? – Ganesh Sanap - MVP Nov 15 '18 at 11:41