The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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:
Solved! Go to Solution.
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'))
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'))
Oct 04, 2023 07:45 AM
That was it - thank you very much.