I am looking to create an Amount Won formulacolumn on my report, which would fill with the Opportunity amount if the opp is marked as closed/won. Ideally I would like to create a formula column vs creating a custom field on the opportunity
It seems possible because I found an article that is looking for something similar but I am getting an error: https://salesforce.stackexchange.com/questions/376071/summary-level-formula-sum-closed-won-opportunities
Error in screenshot below, thanks!
4 answers
Hello @Molly Steffe,
Look like you are missing ")" right after "Closed/Won".
IF (ISPICKVAL(StageName,'Closed/Won'),Amount,0)
