New answers tagged calculated-column
0
My test worked for the following:
Adding hours to a date field: [Created]+(8/24)
=IF(Priority="5",Created+365,IF(Priority="4",Created+5,IF(Priority="3",Created+5,IF(Priority="2",Created+1,IF(Priority="1",Created+(8/24)))))
0
The function DATEDIF(start_date,end_date,unit) says that if the start_date is greater than the end_date, the result will be #NUM!.
So try as follows:
IF(ISBLANK([Authorization Date]),[Receive Date]-TODAY(),[Authorization Date]-[Receive Date])
0
I created a mockup of your scenario and found there was an issue for me using the Today value and would not actually let me create the calculated formula column, so perhaps that could be part of the issue (although I don't see how it could have been working partially.)
Instead using TODAY() seems to allow the formula to work correctly, at least according to ...
0
=TEXT([text_column], "")
0
For future dates, the following returns #Name. I'm glad that you have made it to work in your own way.
=IF(ISBLANK(DateOfEntry),"",DATEDIF(DateOfEntry,TODAY(),"d"))
1
Per my test it works well using your syntax:
=IF(ISBLANK(Date),"",NOW()-Date)
Please add a new calculated column named NowTime to check the result:
NowTime Column:
Result:
0
You can use DATEDIFF to calculate the difference between 2 dates in Number of Days as follow -
=IF(ISBLANK([Last Update]),"",DATEDIF(TODAY(),[Last Update],"d"))
0
To get the Today date in calculated column, you should use Today() instead of Today.
Besides, you don't have to use AND(),OR() function to wrap your condition. This should work for you:
=IF([Report Completed]=TRUE,"No",IF(ISBLANK([Report Completed Date]),"n/a",IF([Report Due Date]>TODAY(),"Yes")))
Updated:
=IF([Report ...
0
If you have 2013 platform workflow, then you may try to create a workflow has a loop which will not end and put a pause 24 hrs action in side the loop. So each time the loop runs will wait for 24 hrs then start the next run
Top 50 recent answers are included
