Skip to main content
Topics#Data ManagementDomanda di Peter Cowen
Peter Cowen (selenity) ha fatto una domanda in #Data Management
22 mar 2017, 11:52

formula to show a 1 or 0 depending on a picklist value and a date

Does anyone know of a formula that will be able to display a 1 if a picklist value is a specific value and today is older than 30 days based on the last modified 

 

The calculation 

 

IF (ISPICKVAL(Field x,"VALUE1"),

 

Last modified + 30 is greater than today

 

(1 to be shown if 30 days after the last modified date is prior to todays date, 0 if 30 days after last modified is post today)
6 risposte
  1. Steve Molis (You Owe Me a Beer, Inc.)
    22 mar 2017, 11:57
    Like this?

     

     

    IF (
    AND(
    TEXT(Field x+ ="VALUE1",
    (DATEVALUE(LastModifiedDate) + 30) < TODAY())), 1,
    0)

     

     
Scrivi una risposta...
0/9000