Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sharepoint Calculated Colums

Posted on 2016-09-06
2
Medium Priority
?
107 Views
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
0
Comment
Question by:Arthit84
2 Comments
 
LVL 15

Accepted Solution

by:
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).
0
 
LVL 20

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...
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In-place Upgrading Dirsync to Azure AD Connect
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

916 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