Solved

Sharepoint Calculated Colums

Posted on 2016-09-06
2
84 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 250 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 17

Assisted Solution

by:Walter Curtis
Walter Curtis earned 250 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Read this checklist to learn more about the 15 things you should never include in an email signature.
As cyber crime continues to grow in both numbers and sophistication, a troubling trend of optimization has emerged over the last year.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
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…

820 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