
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 03, 2023 07:03 AM - edited Oct 03, 2023 07:05 AM
I have a field with a formula that calculates total days using this formula:
Any suggestions are appreciated.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 03, 2023 04:41 PM
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'))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 03, 2023 04:41 PM
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'))

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 04, 2023 07:45 AM
That was it - thank you very much.
