Forum Discussion
Solved
how to filter to Progress value "Completed" to Datediff
Hi - I need help with the code to filter Progress value "completed" to eliminate the "Error in Calculation" in other tickets that are not completed yet.
=IF(ISBLANK([Completed date]),"",DATEDIF([Start date],[Completed date],"d")&" days")
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
1 Reply
=IF(ISBLANK([Completed date]),"",DATEDIF([Start date],[Completed date],"d")&" days")
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)