No announcements

### Condition formula in Calculation based on other columns

Hi everyone, I'm running sharepoint 3.0 on a Windows Server 2003. I have a simple Time Attendance List with 3  main columns, Time In, Time Out, Total ...
| 3 Replies | 8906 Views | Created by Jean Noel Rungassamy - Friday, April 15, 2011 2:35 PM | Last reply by Jean Noel Rungassamy - Friday, April 15, 2011 6:53 PM

### Calculation based on other columns

Hello everyone, I was wondering if someone could help me to solve a challenge with the calculation based on other columns on ...
| 3 Replies | 498 Views | Created by bbbgy - Thursday, June 23, 2016 4:39 PM | Last reply by Sara Fan - Monday, July 4, 2016 9:26 AM

### Calculated (calculation based on other columns)-weekly

Hello Migration User, My recommendation would be to try and simplify it a little bit. Instead of trying to create a calculation that does everything create a couple ...
| 1 Replies | 7230 Views | Created by Suresh Chakravarthy Annavarapu - Thursday, July 10, 2008 8:42 AM | Last reply by Richard Harbridge - Friday, July 25, 2008 8:24 PM

### Calculation question based on other columns

I am trying to build a quotation system based on a list. So far it is all fine, but the client wants to have his quote generated automatically as he fills ...
| 6 Replies | 2585 Views | Created by drazhargraig - Monday, July 30, 2012 10:39 AM | Last reply by SClark_EasyBins - Tuesday, August 7, 2012 2:45 PM

### Sharepoint 2007 - Add formula on value calculated(calculation based on other columns)

in the calculated columns. However there is a
| 3 Replies | 5617 Views | Created by Salvador Varela - Thursday, January 10, 2013 3:34 PM | Last reply by Parvez Akkas - Friday, January 11, 2013 4:00 AM

### Use columns in where clause based on condition

Dear All,  I want to use columns in the where clause based on the value of the variable. Like I have a variable called @categoryID and ...
| 3 Replies | 552 Views | Created by Sammy Williams - Thursday, July 28, 2016 4:12 PM | Last reply by msbi_Dev - Thursday, July 28, 2016 4:30 PM

### Inserting new columns based on the condition!

three columns would be based on the conditions I want to define in the query based on the above ...
| 9 Replies | 946 Views | Created by artistdedigital - Tuesday, February 25, 2014 11:36 AM | Last reply by artistdedigital - Wednesday, February 26, 2014 10:41 AM

### Sum certain columns based on formula

data in my columns based on the Day Number? In Excel I had it as
| 3 Replies | 329 Views | Created by SiGill1979 - Wednesday, October 2, 2019 10:11 AM | Last reply by anthony34 - Wednesday, October 2, 2019 11:50 AM

### Creating 2 columns based on condition

new customer based on their answers. if someone has 3 answers or even 1 but one of them matches "coca cola" I want to give them the value of 1 and if it doesn't ...
| 3 Replies | 788 Views | Created by 404_learn - Tuesday, February 25, 2020 11:43 PM | Last reply by Jingyang Li - Wednesday, February 26, 2020 1:34 AM

### How to show the columns based on the other columns

how to show the columns in the new item page based on the other column?(since the height of new item page is ...
| 1 Replies | 7306 Views | Created by Sruthi Dhanda - Friday, March 11, 2011 5:17 AM | Last reply by Dhirendra Yadav - Saturday, March 12, 2011 5:58 AM

### How to Hide Columns Based on Condition

Step 1- Right click on your required Column here in below example: I wanted to hide
| 6 Replies | 905 Views | Created by balakrishna141 - Tuesday, January 6, 2015 4:58 AM | Last reply by Vaibhav.Chaudhari - Tuesday, January 6, 2015 11:00 AM

### Auto-populate columns based on data of other columns (SharePoint2013)

Hello, thank you for the answer.  I just do not have experience with the formulas.  When creating a new columns with option calculate ...
| 2 Replies | 4806 Views | Created by 1Qwer - Sunday, May 17, 2015 6:15 AM | Last reply by 1Qwer - Friday, May 29, 2015 8:34 AM

### writeback data based on a calculation or formula

We are trying to better understand customer views on social support experience, so your participation in this
| 2 Replies | 1203 Views | Created by blackhole128 - Saturday, October 26, 2013 6:04 AM | Last reply by Meer Al - MSFT - Wednesday, November 6, 2013 11:03 PM

### Installing based on condition.

Hi      I have two executable projects (WinApp1 and WinApp2) in my solution file. In my setup file I add both the projects output.  While ...
| 1 Replies | 9787 Views | Created by msanjayv - Wednesday, August 13, 2008 10:17 AM | Last reply by Figo Fei - Friday, August 15, 2008 4:04 AM

### Calculation formula wrong ?

completion time, in Progress it returns a 6 which I would need a 4 as I am trying to exclude Weekends. This is currently my ...
| 2 Replies | 692 Views | Created by DoubleJay2015 - Tuesday, February 24, 2015 2:59 PM | Last reply by DoubleJay2015 - Thursday, March 12, 2015 3:22 PM

### Problem in doing calculation based on date

Thanks for the reply. Actually we have multiple entries for the tool number for different dates. Moreover this calculation is happening on report side so I have to get all ...
| 5 Replies | 361 Views | Created by Balamurugan Ganesan - Monday, July 18, 2016 11:46 AM | Last reply by Balamurugan Ganesan - Monday, July 18, 2016 12:35 PM

### Calculated columns when the formula differs based on culture

in the culture-specific subsites. The calculation includes the IF() function. I've noticed that in some cultures (English - US), the IF function is defined as ...
| 2 Replies | 6216 Views | Created by jtriemstra - Tuesday, August 7, 2007 6:36 PM | Last reply by Bart de Jonge - Saturday, December 13, 2008 9:55 AM

### Insert data in calculated field based on other columns

based on the two columns (colour and model) if colour = black and model = green the price in the calculated field = ...
| 4 Replies | 5591 Views | Created by fve - Monday, February 2, 2009 12:58 PM | Last reply by Xue-Mei Chang-MSFT - Wednesday, February 4, 2009 6:57 AM