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

Options
coflan60
coflan60
edited 12/09/19 in Smartsheet Basics

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! 

 

 

 

 

 

 

 

 

Comments

  • bdchapin
    Options

    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å
    Andrée Starå ✭✭✭✭✭✭
    Options

    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

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

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