Enterprise & Sell

Enterprise & Sell Answers & Best Practices Calculated Filed if status = closed..

Click here to join this group and curate your SugarClub experience.

Details about this thread

State Suggested Answer
Replies 2 replies
Answers 1 answer
Subscribers 313 subscribers
Views 1289 views
Users 0 members are here

Related content from around SugarClub

Calculated Filed if status = closed..

Manish kumar over 2 years ago

Team,

I am trying to add closed date time using calculated field if the status equal to Closed then add the current date time on filed (new filed date time ) (Closed date ).

How can I write the syntax please help...

Thanx

0 André Lopes over 2 years ago

I believe that this sugarLogic formula may work:

ifElse(equal($status,"Closed"),now(),$closed_date_c)

André Lopes
Lampada Global

Skype: andre.lampada
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Björn Canales Pfisterer over 2 years ago in reply to André Lopes

this one will work but everytime the record is saved or including a formual that relates to another module where a record is edited, the date will be recalculated each time.

I recommend to set this date once the status changes to closed via SugarBPM

Bests

Björn
Cancel
Vote Up +4 Vote Down

Sign in to reply

Verify Answer

Cancel