Solved

Sharepoint Calculated Colums

Posted on 2016-09-06
2
89 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 18

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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
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…

734 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