Forum Discussion
Solved
Project Online - 4000 characters limit for Multiple Lines of text for a Custom Field
I am wondering if there is a way to increase the limit of 4000 characters that there is for an Enterprise Custom Field that is defined as Multiple Lines of Text.
The error messages says: "When using rich text formatting, this limit depends on the extent of the formatting and may be less than 4000 characters."
Therefore, it looks like changing the field formatting to plain instead to rich would remove this limit, but I do not know how to do it.
Thanks in advance for any help on this.
Angus239
hello,
Assuming that your Start(A2) and End(B2) has included a dateyou can use these following formulas to achieve your goal:
Total Hours
=ABS(24*((MIN(TIME(6,0,0),MOD(B2-TIME(18,0,0),1))-MIN(TIME(6,0,0),MOD(A2-TIME(18,0,0),1)))+(MAX(TIME(6,0,0),MOD(B2-TIME(18,0,0),1))-MAX(TIME(6,0,0),MOD(A2-TIME(18,0,0),1)))))Day Shift Hours
=IF(B2>=$J$2,HOUR(B2)-6+MINUTE(B2)/60,0)Night Shift Hours
=F2-D2OVERVIEW:
I've attached a sample file for you
2 Replies
Hello FernandoP2220 ,
It is fixed to "rich text" but I think even if you could change it to "plain text" I think the limit would be around 4000 chars due to the SQL DB column.
Paul
Paul_Mather Thanks so much for your reply.
Regards,
