Set a custom date field value based on a custom field status value

[NuriaMunguia]

Can you help? what am I doing wrong? Thank you in advance, please see attachment. Current formula for calculated field trying to set value on a date field based on status value. IF(BCG Intake Status="2. Awaiting Workgroup Assessment", IF(IS-Awaiting wrkgrp="",$$TODAY,""),"") Nuria Munguia

[BarryBu2]

There's something in the name of your date input field it doesn't like. Put the field name in curly braces: IF(BCG Intake Status="2. Awaiting Workgroup Assessment", IF(ISBLANK({IS-Awaiting wrkgrp}),$$TODAY,""),"") Barry Buchanan Work Management Australia

[NuriaMunguia]

Thank you! somehow when i put those bars it does not recognize the field name , not sure what is it.

[BarryBu2]

No problems :) At a guess, I'd say it's the punctuation (-) in the field name. Barry Buchanan Work Management Australia