Number of days

Question

I have two fields- &nbsp;estimated completion date and date completed. &nbsp;I am trying to create a formula to populate the number of days to complete the project ONLY if date completed is null. &nbsp;I can create the formula and make it work if I leave out the completed part, put am getting an error when trying to incorporate the completed field.------------------------------Angela Bowman------------------------------

markshnier__you · Answer

Can you post your current formula?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

angelabowman · Answer

If(not IsNull([Date completed]),"",ToDays([Estimated completion date]-Today()))------------------------------Angela Bowman------------------------------

angelabowman · Answer

I got it... &nbsp;never mind! thanks.------------------------------Angela Bowman------------------------------

Forum Discussion

Number of days

3 Replies

Related Content

Previous Work Day

Autogenerating Number

Calculate total days with a condition...

Invoice Number Formula

Converting Number to Text

Recent Discussions

An API(?) button to copy fields from the form, to other fields

Pipeline Make Request - Return Make Request JSON Output into fields

Formula using Contain

Moving data from a columnar table to a record based table

Create Child Record, Save and then Edit button