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.

  • What is the exact requirement of yours? – Ganesh Sanap Nov 1 '18 at 16:59
  • Is there any error while creating this field? I guess [TODAY] will not work in calculated formula. – Ganesh Sanap Nov 1 '18 at 17:03
  • What are you trying to achieve using such a formula? The calculated columns do not update themselves automatically if date (today) is changed. It only updates when you update the item. – harshal gite Nov 1 '18 at 17:49
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

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.

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], " ")
  • 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 1 '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 Nov 1 '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 1 '18 at 17:33
  • have you tried this? – Ganesh Sanap Nov 15 '18 at 11:41

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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