
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?
Don't use calculated column type in SharePoint. Do the calculation in Powerapps using text and number type columns from SharePoint.