Skip to main content
Solved

Need a field that reflects a number beginning with 01 based off a formula in another field

  • October 3, 2023
  • 2 replies
  • 39 views
K
Forum|alt.badge.img+5

I have a field with a formula that calculates total days using this formula: 

IF({Status 📝}="Unassigned", WORKDAY_DIFF({Create Date},TODAY(),'2023-09-04'), "N/A")
The formula works, but returns results of 1, 2, 3 etc., which when i try to use this column in a graph it does not sort correctly.  I need the results to be 01, 02, 03 to be able to sort in ascending or descending order or I need a field that reads the formula field and converts it to a number that can be sorted. 
Any suggestions are appreciated. 

Best answer by Sho

It appears that the field is being sorted as a string type because of the "N/A" in the return value of false. If the return value is removed, the field should be sorted as numeric.

IF({Status :pencil:}="Unassigned", WORKDAY_DIFF({Create Date},TODAY(),'2023-09-04'))
1 Attachments

2 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • Answer
  • October 3, 2023

It appears that the field is being sorted as a string type because of the "N/A" in the return value of false. If the return value is removed, the field should be sorted as numeric.

IF({Status :pencil:}="Unassigned", WORKDAY_DIFF({Create Date},TODAY(),'2023-09-04'))
K
K
Forum|alt.badge.img+5
  • Kitty_Matz
  • Author
  • New Participant
  • October 4, 2023

It appears that the field is being sorted as a string type because of the "N/A" in the return value of false. If the return value is removed, the field should be sorted as numeric.

IF({Status :pencil:}="Unassigned", WORKDAY_DIFF({Create Date},TODAY(),'2023-09-04'))

That was it - thank you very much.

Terms & ConditionsAccessibility statement