Expand my Community achievements bar.

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

Avatar

Level 5
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
3 Replies

Avatar

Level 8
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

Avatar

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

Avatar

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