New answers tagged

0

Change the calculated field through =TEXT(ID,"0"), which converts a value to text in a specific number format: Then lookup it in another list as shown below: More information: https://support.microsoft.com/en-us/office/text-function-4b46e545-e612-4c84-ac23-edfa68007945


1

I have created below formula to calculate week number starting on 1st of Jan 2022. Refer attached screenshot for the output. =ROUNDDOWN(DATEDIF(DATE(2022,1,1),[datefield],"d")/7,0)+1 You need to replace datefield with your date column, the data type returned by this formula can be used as Number or single line of text. This should work for any ...


0

Please follow the steps: 1.Create a Choice column named [Impacto Inherente] 2.Create a Calculated column named [CalTest1] and use the below Formula: =IF([Impacto Inherente]="Crítico",400,IF([Impacto Inherente]="Mayor",300,IF([Impacto Inherente]="Moderado",200,IF([Impacto Inherente]="Menor",100,IF([Impacto Inherente]=&...


0

update 2022-01 - [Me] works on SharePoint online


0

Here are two columns, a date and time column named Deadline date, a calculated column named cal. =if([Deadline date]-Today()=30, CONCATENATE("30","-",TEXT([Deadline date],"yyyy-mm-dd")), if([Deadline date]-Today()=60, CONCATENATE("60","-",TEXT([Deadline date],"yyyy-mm-dd")), if([Deadline date]-Today(...


1

I changed the *1440 to *1448 and that achieved the desired results!


0

It's simple, please apply the following steps : The Status column must be a Calculated Column Apply the following formula : If the current date is either less than the closed date OR greater than the opened date then the status should be OPENED, else if it's between'em than it should be CLOSED =If(OR(Closed>=NOW(),Opened<=NOW()),"Open",&...


0

Please use the below Formula: =(IF(OR(ISBLANK([Quote Start Time]),ISBLANK([Quote Complete Time])),"",IF(AND((WEEKDAY([Quote Complete Time],2))<(WEEKDAY([Quote Start Time],2)),((WEEKDAY([Quote Start Time],2))-(WEEKDAY([Quote Complete Time],2)))>1),(((DATEDIF([Quote Start Time],[Quote Complete Time],"D")))-(FLOOR((DATEDIF([Quote Start ...


0

Using this formula: =IF(OR(ISBLANK([Start Date]),ISBLANK([End Date])),"",IF(AND((WEEKDAY([End Date],2))<(WEEKDAY([Start Date],2)),((WEEKDAY([Start Date],2))-(WEEKDAY([End Date],2)))>1),(((DATEDIF([Start Date],[End Date],"D")))-(FLOOR((DATEDIF([Start Date],[End Date],"D"))/7,1)*2)-2),(((DATEDIF([Start Date],[End Date],"...


0

As you are using Power automate to create a site without space, you don't need to create calculated column for this. You can use replace function in expression in Power automate to remove the spaces from text. Syntax of expression will be like: replace('Project resolving any issues', ' ', '') You can also pass variables or columns from SharePoint list in ...


Top 50 recent answers are included