Sharepoint Calculated Colums

Posted on 2016-09-06
Medium Priority
Last Modified: 2016-09-07
Hello everyone, I am trying to create a calculated colums in Sharepoint.

The goal is to when a user chose a specific value in a drop down box the calculated field should produce a date when the drop down change

here is a example

Delivery date colum:
=if(Deliverystatus = "deliveried","[Today]")

Thanks everyone in Advance
Question by:Arthit84
LVL 15

Accepted Solution

Greg Besso earned 1000 total points
ID: 41787729
Hi there, calculated columns only work once the list item is changed and saved, they are not like JavaScript OnChange events being fired (unless they have made an awesome improvement with 2016 release that I'm not aware of yet).
LVL 21

Assisted Solution

by:Walter Curtis
Walter Curtis earned 1000 total points
ID: 41787746
As mentioned above, this column is only calculated when the item is saved. JavaScript of jQuery should be able to help you here.

Good luck...

Featured Post

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

586 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question