2

Instead of creating a date & time column with Today's date as default value, create a calculated column directly using below formula: =DATEDIF([Start Date], TODAY(), "Y") Output: Documentation: Calculated Field Formulas Useful thread: How to use Today and Me in Calculated column Note: Sometimes comma(,) does not work in formula (I am not ...


1

Looks like you simply need to put "n/a" into the FALSE parameter of the IF statement. I assume that you are aware of the IF() syntax, i.e. IF(<condition>, <do when true>, <do when false>) So, for your formula that would be =IF(Error="yes", Concatenate("ERR",[ID]),"n/a") I've also removed the ...


1

I just tried the same steps as given below & it works for me: Create a calculated column with formula (with return type as Single line of text). =IF(MONTH(NOW()) = MONTH([DateField]), "Yes", "No") Where DateField is my date column. Edited existing view with below filters: Original list (All items): Output - Filter list view: ...


1

Your formula seems incorrect. If you notice the difference in dates 9/1/2021 - 9/21/2021 = -20 but your screenshot is showing -19. Try using this formula below =IF(InductionCallDate>TodayDt,DATEDIF(TodayDt,InductionCallDate,"d"),CONCATENATE("-",DATEDIF(InductionCallDate,TodayDt,"d")))


Only top voted, non community-wiki answers of a minimum length are eligible