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.