Date Calculation

edited 12/09/19

I have 3 columns. 1 column is the date that the time begins, the 2nd is a factor that is either 1.5, 3 or 5. It is always one of these three numbers. The 3rd column is for the end date that is auto-calculated by taking the date in column 1 and multiplying it be the factor selected in column 2. How do I do that? I am really racking my brain about this.

Thank you.

• ✭✭✭✭✭✭

Hi,

What measure is the Aging For? Days, Weeks or Months? Let's say that it's days. Do you want the Date Aging Ends to be 5 (3 or 1,5) days in the future?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

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.

• edited 11/19/18

I need the aging output to be Month, Day and Year in the final output. I should have put on the original post that it is a multiplication problem.

(Orig. Date)*(Selected Value - 1.5, 3 or 5) = (Future Date)

The selectables are for number of years.

• ✭✭✭✭✭✭

Ok.

I would translate the selectable list to days, and then it will work but if you need the reference to show as it does now you could have a helper column to calculate the values in the background.

Would that work?

Best,

Andrée

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.

• OK. Good thought. I will see what that looks like and post here again if I can't get it to work.

• ✭✭✭✭✭✭

Great!

Let me know if you have any questions!

Best,

Andrée

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.