Skip to main content
Solved

Having a wee bit of brain trouble today with a formula

  • May 9, 2023
  • 3 replies
  • 24 views
RonniEloff_VKDe
Forum|alt.badge.img+19

I have a formula that worked but I decided to go and mess with it.

I have a Date field that is the date of the task action

I have a Days to next action field to add to Date field to define next time to attempt the task (normally a callback)

I have a Next Task Date formula field that shows the Date for the next task based on Date + Number of Days  - and it was nicely working

The formula in the Next Task Date field looked like this - DATEADD({Date }, {Days to next action}, 'days')

However I don't want the formula to put anything in the Next Task Date if the Numbers of days is blank

Here is my current formula

If ({Days to next action}=BLANK(), DATEADD({Date }, {Days to next action}, 'days'))

It's failing and I can't figure out why.

Thanks in advance for helping

Best answer by TheTimeSavingCo

Try:

 

IF( {Days to next action}, DATEADD({Date}, {Days to next action}, 'days') )

 

3 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6410 replies
  • Answer
  • May 10, 2023

Try:

 

IF( {Days to next action}, DATEADD({Date}, {Days to next action}, 'days') )

 

Adam, Airtable Consultant - thetimesaving.company
RonniEloff_VKDe
Forum|alt.badge.img+19
  • RonniEloff_VKDe
  • Author
  • Inspiring
  • 66 replies
  • May 10, 2023

Try:

 

IF( {Days to next action}, DATEADD({Date}, {Days to next action}, 'days') )

 


Thanks.  Can I ask why Blank() wouldn't work here.  It was a solution from another problem I found in the Community that almost mimicked my issue of what I was trying to accomplish

TheTimeSavingCo
Forum|alt.badge.img+31

Thanks.  Can I ask why Blank() wouldn't work here.  It was a solution from another problem I found in the Community that almost mimicked my issue of what I was trying to accomplish


I'm not sure either I'm afraid heh, hopefully someone else can answer that

Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement