Task Condition html for Date Completed
In Project Manager, I'm using HTML to link the Task Condition buttons to Start and End Dates, as opposed to the manually updated "status" menu. This way, the "inactive" button will appear automatical...
Forum Discussion
As a matter of simpler syntax, I would get rid if the nested IFs and hence be able to get rids of the )))))) at the end of the formula. It would just with 1 ). But that will not fix your problem, just make it easier in the future for you write QuickBase formulas.
That is needless nesting because that is how you need to do it in excel, but you do not have to do it that way in Quick Base.
Can you tell me what field type the field [Start] is? it would be unusual to have to convert a field to a Date field unless it was a date/time field type. Maybe Start is just a text field?
For example if you make a stand alone field with the formula ToDate([start]) what is the result.
That is needless nesting because that is how you need to do it in excel, but you do not have to do it that way in Quick Base.
Can you tell me what field type the field [Start] is? it would be unusual to have to convert a field to a Date field unless it was a date/time field type. Maybe Start is just a text field?
For example if you make a stand alone field with the formula ToDate([start]) what is the result.