Forcing a blank cell in a formula

1

Hi! I’m trying to create a formula that calculates an end date which is the easy part. StartDate+10 is what I need. However, I don’t want it calculating a default date in the due date column unless I have entered a start date. Currently I am getting a solution of 09/01/1900 for all blank start date cells. Makes total sense, I just don’t want the erroneous due date showing on my linked calendar.

2

Hi @Kimberley_Shepherd,

Would you mind to share a copy of the dummy doc?

Thanks

1 Like
3

Nm! :stuck_out_tongue: I got it lol

FYI:
For the due date column enter this formula

switch(IsNotBlank(thisRow.[Start Date]),true,thisRow.[Start Date]+10)

1 Like
4

Thanks for jumping in @Jean_Pierre_Traets! Much appreciated!