New answers tagged

0

Try this: =IF(ISBLANK([Date1]),DATEDIF([Created],[Date2],"d"),DATEDIF([Date1],[Date2],"d"))


0

Try this formula: =IF(ISBLANK([Date1]), DATEDIF([Created], [Date2], "d"), IF(NOT(ISBLANK([Date1)), DATEDIF([Date1], [Date2], "d"), "")) OR =IF(ISBLANK([Date1]), DATEDIF([Created], [Date2], "d"), DATEDIF([Date1], [Date2], "d")) Note: Sometimes comma(,) does not work in formula (I am not sure but it is based ...


0

Used a little different approach (using AND/OR) to accomplish the same requirements (if I understood it correctly). Update the following formula with the column names and values in your list as required (I've used fewer column values for this example). =IF(OR(ClassType="Public",ClassType="De-identified data"),"Yes",IF(AND(OR(...


0

For me the normal excel fx worked well =Today()+5


0

Solution1 Create a Calculated column: When the focument Title is Driver Captain, the value is CT0000DC; when the document Title is Driver Instructor, the value is CT0000DI. =IF(Title="Driver Capatain","CT0000DC",IF(Title="Driver Instructor","CT0000DI","")) Solution2: Create a MS Flow: When the document Title ...


0

We cannot use file name in calculated column formula. It's a known limitation of SharePoint. There is a SharePoint UserVoice for this. You can vote here: Use filename in calculated field Workaround: Create a new text field & populate its value using workflow/Power automate flow on item creation/update. Hide this field from property forms. Use workflow ...


1

Calculated columns cannot be shown on list forms using out of the box capabilities. You need to customize the list form using Power Apps, reproduce the calculated column value logic using Power apps formulas & show the calculated value on list form using label control.


1

It's a known limitation of SharePoint. We cannot use file name in calculated column formula. There is a SharePoint UserVoice for this. You can vote here: Use filename in calculated field Workaround: Create a new text field & populate its value using workflow on item creation/update. Hide this field from property forms. Use workflow to updated the Title ...


0

Use this formula: =IF([Impact]="High", IF([Urgency]="High", "1", IF([Urgency]="Medium", "2", IF([Urgency]="Low", "3", ""))), IF([Impact]="Medium", IF([Urgency]="High", "2", IF([Urgency]="Medium", "3", IF([Urgency]="Low", ...


0

Calculated columns are only going to be calculated at creation/modification so showing remaining time at display isn't possible with calculated columns. If you are on SharePoint Online or SharePoint 2019 using the modern experience you can use Column Formatting to do this using the @now placeholder. If you are using the classic experience or in a previous ...


0

If [Annual pack days diff] is of "Date" type [Public Liability expired?] & [Employers Liability expired?] are of "Yes/No" type then use this formula: =IF(AND([Annual pack days diff] > Today(), NOT([Public Liability expired?]), NOT([Employers Liability expired?]), "Yes", "No")) If [Annual pack days diff] is ...


2

Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,). Try using this: =DATEDIF([Dato1];[Dato2];"d")


Top 50 recent answers are included