Keeping cell with a formula even if its blank...

coflan60

Hello...

I've taken over SmartSheet from my predecessor in my workplace. 

I have over 30 different process steps in the Due Date column that work off the actual date for a writer's task process.

The two columns of information are Due Date (1st Column) and Actual Date (2nd Column).  How do I keep the formulas in the (30) cells of the column by keeping the cells unpopulated?

Here is the information in SmartSheet:

The 1st Column has formula fx=[Actual Delivery Date] 1(Row)+3(3 days) and

fx=[Due Date] 3(Row) + 7(7 days)

2nd Column has no formula just the Actual Delivery Date

If anyone can help I'd be very grateful! 

 

 

 

 

 

 

 

 

bdchapin

I don't follow. What are you trying to do?



I see that you have a "Due Date" and an "Actual Date" and some formulas based on those dates, but I don't understand what you question is or what your trying to do. 



If you simply want to add days to a date field, make sure your destination column is a date field and you can use something like:

=Start1 + 2

 

if you want to calculate a date that omits weekends, use something like this:

=WORKDAY(Start2, 7) 

-b

Andrée Starå

Hi,

Can you upload a screenshot or share the sheet so it would be easier to help you?

Best,

Andrée Starå - Workflow Consultant / Get Done