Hot answers tagged

6

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)


2

The mentioned methods do not work for SharePoint custom forms, as is shown in the UserVoice post. And also quoting the community announcement post: LaunchTarget does not work in embedded apps, such as apps hosted in Power BI or SharePoint, and should be avoided. Using Launch function for redirection on the form (in OnSuccess property, for example) will ...


2

Set visible property of label control to: Not(Dropdown1_1.Selected.Site <> "Please Select") Update from comments: As @RobertLindgren suggested, below should also work for you: Dropdown1_1.Selected.Site = "Please Select"


1

Use below: If(IsBlank(TextInput7.Text) || IsBlank(TextInput1_4.Text), Disabled, Edit) OR If(Or(IsBlank(TextInput7.Text), IsBlank(TextInput1_4.Text)), Disabled, Edit)


1

Please the following steps: Step1: Select an item in the list to open the "Edit Form" panel Step2: On the "Edit Form" panel, click on "Edit columns" link Step3: On the "Edit columns in the form" panel, select column and click "Edit conditional formula" Step4: On the "Edit conditional formula for xxx ...


1

Neither the new Image column or the Hyperlink or Picture column can be directly updated using flow. A workaround is to use Send HTTP request to SharePoint action to update Hyperlink or Picture field. Please see the references here: Microsoft Flow – Update a Hyperlink or Picture field. / MS Flow and SharePoint Picture Columns: A Trick.


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

Here is the Form validation formula: =IF(NOT(ISBLANK(DueDate)),IF(DueDate>(TODAY()+(7-WEEKDAY(TODAY(),2)+1+7)),TRUE,FALSE),TRUE) Find days from TODAY() to the first Monday using WEEKDAY(date,return_type), where date is TODAY(), return_type=2. It returns weekdays numbered 1 (Monday) through 7 (Sunday) Add days (step 1) plus 1 to TODAY() to get the first ...


1

The logic would be a lot easier to achieve in a SharePoint list - using Calculated column. Although I do not recommend writing the logic all in PowerApps since it increases the loading time tremendously, it is workable. ASSESSMENT RATING field should be Read-Only either way. Assuming you have this PowerApps form attached to a SharePoint list, column value ...


1

Try below formula in your calculated column: =IF([Choice]="Doesn't align to current priorities","0",IF([Choice]="Somewhat aligns to current priorities","5",IF([Choice]="Aligns strongly with current priorities","10","-"))) Here, [Choice] is the column from which formula compares the values. See the values in my list view:


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

"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