Forum Discussion

Qrew Assistant Captain

8 years ago

Formula Help (Planned Duration & Estimated Date)

Hi, I have 2 fields that need to be considered for calculation to pull up a "duration" (in # of days) and "estimated date" (in date) in the 3rd and 4th field, respectively. Field 1 (text-multipl...

App builders

Ask about Quickbase functionality

Formulas and functions

EvanMartinez

Moderator

8 years ago

Looking at my formula again it is probably because I forgot a comma after ="E". Try this slight adjustment again and if it still throws a syntax error let me know.

If([Template Type]="A" or [Template Type]="B", [Start Date]+Days(30),
If([Template Type]="C", [Start Date]+Days(60),
If([Template Type]="D",[Start Date]+Days(90),  If([Template Type]="E",[Start Date]+Days(120), null))))

Forum Discussion

Formula Help (Planned Duration & Estimated Date)

Related Content

Duration Fields with Pipelines

Duration between record creations

Create a formula duration over 5 years

Duration Formula

Formula Checkbox and Duration