No announcements
Found 1543919 threads
-
0 Votesif statement in calculated columns
Hi, Yes you can use IF statements in a calculated columns to build a function\equation.Answered | 1 Replies | 6686 Views | Created by Ash000 - Tuesday, June 23, 2009 8:55 PM | Last reply by Par4theChords - Tuesday, June 23, 2009 10:07 PM
-
3 Votes
Multiple calculations on columns in a select statement
I would then need to calculate the time between the first calculated value(val1) and column 4 or column 5 depending on which value is not null...I ...Answered | 9 Replies | 2116 Views | Created by Brian205 - Thursday, February 21, 2013 9:49 PM | Last reply by Naomi N - Tuesday, February 26, 2013 1:46 PM -
1 Votes
Calculated Column...too many If Statements?
Hi, A calculated column doesn’t allow more than 7 nested IFs.Answered | 2 Replies | 10958 Views | Created by lgh5000 - Thursday, October 21, 2010 2:52 PM | Last reply by lgh5000 - Thursday, October 21, 2010 3:59 PM -
1 Votes
Calculated column - if statement
I have no idea why I didn't think of that, but of course it works like a charm with the ;'s Also, changing the "Region" - "Locale" under Site Settings ...Answered | 5 Replies | 6467 Views | Created by Pal-Martin - Thursday, November 6, 2014 8:47 AM | Last reply by romeo donca - Thursday, November 6, 2014 12:13 PM -
1 Votes
column is not empty or blank in an IF statement - in a calculated column formula sharepoint 2016
Click here to learn new features.Answered | 2 Replies | 1835 Views | Created by Sarra21 - Friday, November 29, 2019 4:15 PM | Last reply by Lisa Chen1226 - Tuesday, December 3, 2019 9:35 AM -
1 Votes
Sharepoint Calculated Date column
http://blog.pentalogic.net/2008/11/working-days-weekdays-holidays-sharepoint-calculated-columns/ Also to work on the ...Answered | 5 Replies | 3138 Views | Created by Anu L V - Friday, February 14, 2014 1:44 PM | Last reply by R.Mani - Wednesday, February 19, 2014 12:05 PM -
0 Votes
SharePoint 2016 List - Calculated Column
I created the Workflow and all is working great.Answered | 4 Replies | 3591 Views | Created by dRob59 - Monday, February 5, 2018 5:56 PM | Last reply by Wendy DZ - Tuesday, February 6, 2018 2:49 AM -
2 Votes
Sharepoint Calculated column with [Today]
Are you either using the fake column trick (that doesn't update) or using a default value instead of a *calculated column*?Answered | 12 Replies | 64748 Views | Created by US- - Thursday, October 21, 2010 2:47 PM | Last reply by Twychopath - Tuesday, January 3, 2017 8:22 PM -
1 Votes
2007 sharepoint - calculated columns
Worked perfect!Answered | 2 Replies | 1032 Views | Created by Mustard2012 - Monday, December 2, 2013 5:19 PM | Last reply by Mustard2012 - Tuesday, December 3, 2013 4:49 PM -
2 Votes
If statement vs. calculated column
Hi AlexMartini, A calculated column is just like any other column in a table and you can use it in any part of a report.Answered | 2 Replies | 726 Views | Created by AlexMartini - Tuesday, October 18, 2016 12:52 AM | Last reply by Angelia Zhang - Tuesday, October 18, 2016 9:10 AM -
0 Votes
sharepoint calculated Column issue
Hi Lalit, Or you can go with a custom Event Receiver which can be triggered when there is item created of ...Answered | 2 Replies | 640 Views | Created by Lalit Kasa - Tuesday, May 31, 2016 8:59 AM | Last reply by Patrick_Liang - Wednesday, June 1, 2016 2:27 AM -
0 Votes
Query based on SharePoint 2013 Calculated Column
Hi Vikas Mishra, It is by default that it will export the calculated column and its related column when exporting to excel.Answered | 3 Replies | 931 Views | Created by VIKAS SHANKAR MISHRA - Tuesday, March 8, 2016 9:30 AM | Last reply by Sara Fan - Wednesday, March 9, 2016 8:37 AM -
3 Votes
Show a Sharepoint Calculated Column In InfoPath2007
Try a different path, without using the calculated column.Answered | 18 Replies | 21261 Views | Created by Adriano Coura - Monday, November 19, 2007 12:58 PM | Last reply by paultru - Tuesday, August 23, 2011 8:20 PM -
4 Votes
SharePoint Calculated Column - IF a number column is blank
As a side note, there is a good article on the MSDN site that goes through a lot of formula examples when using calculated columns or validation.Answered | 3 Replies | 48748 Views | Created by Millard1 - Friday, September 27, 2013 10:10 AM | Last reply by Millard1 - Friday, September 27, 2013 12:21 PM -
0 Votes
Filtering is not worked on calculated column of sharepoint 2013 list view webpart
Hi, I have created calculated column of first name and last name has candidate name.Answered | 3 Replies | 2648 Views | Created by Sushanth Y - Tuesday, December 22, 2015 10:39 AM | Last reply by Linda ZL - Thursday, December 24, 2015 9:48 AM -
2 Votes
SharePoint Calculated Column
Create a calculate column and type formula RIGHT([Copy Name],8), select Date and Time type returned from this formula.Answered | 6 Replies | 19458 Views | Created by SRPD - Thursday, May 5, 2011 8:38 PM | Last reply by Emir Liu - Thursday, May 12, 2011 12:43 PM -
0 Votes
SUM of Calculated Column Value SharePoint 2010
Here is an example for your reference: Sum Calculated Columns: ...Answered | 1 Replies | 1353 Views | Created by SP2019 - Thursday, October 8, 2015 4:41 PM | Last reply by Dennis Guo - Friday, October 9, 2015 2:13 AM -
1 Votes
Calculated Columns for a Risk Matrix
Hi i agrree with Grace WR and I would add that if you conditions to set excalation option and baed on multiple possibilities if all 4 choice ...Answered | 3 Replies | 1097 Views | Created by Ken Craft - Tuesday, March 28, 2017 6:10 PM | Last reply by Ken Craft - Monday, April 3, 2017 5:18 PM -
0 Votes
Calculated column using CASE statement not working
The first 2 columns are CHAR(2) and the WPAMT is DECIMAL(7).Answered | 5 Replies | 2763 Views | Created by Jakets25 - Thursday, November 9, 2017 11:36 PM | Last reply by RichardLees - Sunday, November 12, 2017 11:51 PM -
0 Votes
Creating a calculating column
José Quinto Zamora SharePoint and Search Specialist at SolidQ(http://www.solidq.com) MCITP and MCPD in SharePoint 2010 ...Answered | 1 Replies | 3047 Views | Created by Bunta80 - Wednesday, June 13, 2012 1:41 PM | Last reply by José Quinto Zamora - Thursday, June 14, 2012 8:34 AM - Items 1 to 20 of 1543919 Next ›
No announcements
