Hot answers tagged

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

Basic syntax for IF statement in calculated formula is: IF(logical_test,value_if_true,value_if_false) So, try to write down your formula in above format. Note: Sometimes comma(,) does not work in formula (I am not sure but it is based on something language on your site). So in that case use semicolon(;) instead of comma(,). For detailed information and ...


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