Forum Discussion
Arnie_Howes
Jun 13, 2022Brass Contributor
If/Then ISBLANK in SharePoint Online Calculated Column
I'm sure this is a common need, but I'm drawing a blank. I am building a Calculated Column for which I need an if/then statement to check the "PermitActual" field and if it is blank, insert today's ...
- Jun 13, 2022
Arnie_Howes try it with =IF(PermitActual=0,TODAY(),PermitActual)
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
RobElliott
Jun 13, 2022Silver Contributor
Arnie_Howes try it with =IF(PermitActual=0,TODAY(),PermitActual)
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
Arnie_Howes
Jun 13, 2022Brass Contributor
RobElliott, it worked like a charm. Thanks!