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.
Would you mind to share a copy of the dummy doc?
Nm! I got it lol
For the due date column enter this formula
switch(IsNotBlank(thisRow.[Start Date]),true,thisRow.[Start Date]+10)
Thanks for jumping in @Jean_Pierre_Traets! Much appreciated!