Forum Discussion

Hopeisgood1's avatar
Hopeisgood1
Copper Contributor
Jan 14, 2025
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.     
microsoft lists
Microsoft365
  • Rob_Elliott's avatar
    Rob_Elliott
    Jan 20, 2025

    =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)

Rob_Elliott's avatar
Rob_Elliott
Silver Contributor
Jan 20, 2025

=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)

Resources