Dear Sir,
I'm trying to use calculated value in share point but doesn't work
=IF(ISERROR(FIND("TBC",[Test Date])),"","TBC"),[Test Date]-[TodayDate]
Basically, IF there is TBC in Test Date, then I want Due become TBC. Also, I would like to deduct Test Date (basically project completion date) - TodayDate to get how long it has been due or to be due.
Any help on this?


Report
All responses (
Answers (