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

edited 12/09/19 in Smartsheet Basics


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) 


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭


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


    Andrée Starå - Workflow Consultant / Get Done


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.