Hot answers tagged calculated-column
You can use below formula =CONCATENATE("FY",YEAR(Date+274)," Q", IF(Month(Date)>10,1,IF(Month(Date)>7,4,IF(Month(Date)>4,3,2)))) Logic CONCATENATE can be used to form formatted TEXT First find FY - So here we can use the same Excel formula FY + Year(Date+274) To calculate Quarter - We need to use IF statements. It take form ...
You can use a calculation for this. Create the column reminderdate as a calculated column of the Date and Time type. Then use the following calculation: =DATE(YEAR([dueDate]),MONTH([dueDate])+4,DAY([dueDate])) If you are using another regional language than english, you may have to replace all commas (,) with a (;). Every time the column dueDategets a ...
As you cant use the People or Group Column in the formula, i think the workaround is: create another text column create a workflow which will copy the items from people or group column into text column. Now use the Text column in your formula. You can exclude that column from your view to avoid the misunderstanding.
Try =IF(ISBLANK([Date]), "", TEXT([Date], "mmm"))
Only top voted, non community-wiki answers of a minimum length are eligible