Forum Discussion
Format a number column based on values in a different column
this is likley simple, and I could do it easily in infopath, but since it is no longer supported, i need a different solution. Open to calculated column or power all (I guess--have not found them eas...
BobbieWinter all you need is a calculated column with the following formula with the data type returned as a number with no decimal places:
=IF(Status="Completed",
IF(Activity="G",1,
IF(Activity="H",2,
IF(Activity="I",3,
IF(Activity="J",4,
IF(Activity="K",5)))))
,0)
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)