Hot answers tagged

4

Try to use Round function to rounds a number to a specified number of digits. Round Syntax = ROUND(number,num_digits) Where the num_digits the number of digits to which you want to round the number. In your case, try the following: =ROUND(MAX(0,TodayDate-[Contract Commencement Date])/([Contract End Date]-[Contract Commencement Date]), 1) Read details ...


3

You could set the calculated column as below:


2

This question might help. The accepted answer says to just put your current column formula inside ROUND: =ROUND([your formula here],0)


1

Try below formula: =IF([Choice]="Banana",IF(OR(ISBLANK([Start date]),ISBLANK(End date)),false,true),true) This satisfy the condition: If [Choice] is equal to "Banana" then user cannot leave Start date or End date columns blank. Note: Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on ...


1

SharePoint Column Validation Examples for your reference: https://techtrainingnotes.blogspot.com/2015/10/sharepoint-column-validation-examples.html


1

Use the formula. int(triggerBody()?['DateDif'])


1

"9:35:00 AM" is not a date or a time. It is just text. In any case using ">" will have issues with one and two digit times. ("12" is less than "9" when compared as text.) The TIME function creates a time from three number: Hour, Minute, Second. Change: =IF(AND([SignIn]>"9:35:00 AM",[SignIn]<"10:15:00 AM"]),"Late","") to something like: =IF( AND( ...


1

The syntax for add function is like below: add(<summand_1>, <summand_2>) Where, <summand_1>, <summand_2> should of type Integer, Float, or mixed. Reference: Flow - add() function. Solution: For your case you can use Compose action to enter the Dynamic content of the corresponding SharePoint field and then use add() function to ...


1

Use below formula: ="<DIV style='font-weight:bold; font-size:24px; color:"&IF([Review Status]="Approaching","Green",IF([Review Status]="OverDue","Red","Yellow"))&";'>•</DIV>" Note: Return this field as Number field. Microsoft blocked handling HTML markup in SharePoint calculated fields for recent versions, see here. If you are using ...


1

Try using below formula: =IF([ChoiceField]="New York","Person1",IF([ChoiceField]="Florida","Person2",[ChoiceField])) This formula is similar to: if(ChoiceField === "New York") { CalculatedValue = "Person1"; } else if(ChoiceField === "Florida") { CalculatedValue = "Person2"; } else { CalculatedValue = ChoiceField; } IF Function: Returns ...


1

You would need to create an SPFx FieldCustomizer Essentially you then would write @override public onRenderCell(event: IFieldCustomizerCellEventParameters): void { event.domElement.innerHTML = `<div>${event.fieldValue.replace(/[,\.]/g, "")}</div>`; } or whatever modifications you'd want to make.


1

You need change the validation formula to this: =TEXT([Data documento],"yyyy")="2018" Try to use this in list validation. Go to list settings-> validation settings:


1

I don't know all your requirements. But I guess you want "Billing Status" field to be mandatory if "A La Carte" is equal to "Yes"(Correct me if I am wrong). In this case you need to use below formula: IF([A La Carte]="Yes",NOT(ISBLANK([Billing Status])),TRUE)


1

Make sure you've got the appropriate spaces between terms. So between any [Field] or any operator (+,*,/), and I think your parenthesis, too? Your syntax looks correct to me. If the spaces doesn't fix the issue, try making a new field to do the calculation and call it something like NumeratorAsPercent then make your function ( NumeratorAsPercent | ...


1

I resolved it using below formula: =IF(ISBLANK([Assessment]), "",IF(ISBLANK([Reassessment]), DATE(YEAR([Assessment])+3,MONTH([Assessment]),DAY([Assessment])), DATE(YEAR([Assessment])+6,MONTH([Assessment]),DAY([Assessment]))


Only top voted, non community-wiki answers of a minimum length are eligible