Help

Formula to show in progress, under time and overdue depending on other fields

Solved
Jump to Solution
1224 2
cancel
Showing results for 
Search instead for 
Did you mean: 
CameronG
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi guys,

I currently have the below in a grid view.

CameronG_0-1690493591325.png

I would like to have a formula in the "Timeframe Status" column which will do the following:

1. Check whether text has been added to the "RFI Resolution" field.

2. If the "RFI Resolution" field is not empty, then check the hours between the "Date Created" field and the "Due by" field. If this is less than 48 hours, then return the text "Within time". If it is equal to or greater than 48 hours, then return the text "Past due". I would like the hours to be shown decimal 0.00

3. If the "RFI Resolution" field is empty, then return the text "Ongoing". Again, I would like the hours to be shown decimal 0.00

Thanks

1 Solution

Accepted Solutions
AirOps
7 - App Architect
7 - App Architect

Hi @CameronG

 

Try this: 

 

IF({RFI Resolution},
IF((DATETIME_DIFF({Due by}, {Date Created}, 'minutes')/60) < 48,
"Within Time: " & ROUND((DATETIME_DIFF({Due by}, {Date Created}, 'minutes')/60), 1.00),
"Past Due: " & ROUND((DATETIME_DIFF({Due by}, {Date Created}, 'minutes')/60), 1.00)),

"Ongoing: " & ROUND((DATETIME_DIFF({Due by}, {Date Created}, 'minutes')/60), 1.00)
)
 
I hope this helps! 
 
Chantal

 

 

See Solution in Thread

2 Replies 2
AirOps
7 - App Architect
7 - App Architect

Hi @CameronG

 

Try this: 

 

IF({RFI Resolution},
IF((DATETIME_DIFF({Due by}, {Date Created}, 'minutes')/60) < 48,
"Within Time: " & ROUND((DATETIME_DIFF({Due by}, {Date Created}, 'minutes')/60), 1.00),
"Past Due: " & ROUND((DATETIME_DIFF({Due by}, {Date Created}, 'minutes')/60), 1.00)),

"Ongoing: " & ROUND((DATETIME_DIFF({Due by}, {Date Created}, 'minutes')/60), 1.00)
)
 
I hope this helps! 
 
Chantal

 

 

CameronG
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks Chantal