Formula to change certain Dates

Hi I am in need of some urgent help. When the date paid has been changed I want the Company Review date to change by a Full Year and the once that has change I want the due date to change by 2mths.

It would be much appreciated if someone could please help me out.

Find more posts tagged with

Formulas

Comments

Paul Newcome

Are you able to provide some screenshots with sensitive/confidential data hidden or replaced with "dummy data"?

Just based on your post I would think that entering this into the Company Review Date

=[Date Paid]@row + 365

and this in the due date field

=[Company Review]@row + 60

Should be a good start.

Sign in to join the conversation!

Quick Links

Trending discussions

Netdays Formula
I am wanting to calculate Netdays but only if there is data in 'Corrective Action 1' I am currently using this formula: =IF(ISBLANK([Date Action 1 Complete]@row ), NETDAYS([Date of Event]@row , TODAY()), NETDAYS([Date of Event]@row , [Date Action 1 Complete]@row )) How do I adjust it to only pull a date when Corrective…
Re-write a formula to make it Column Formula compatible
I have Concept phase projects that can result in multiple Phase 1 projects being generated from one Concept Review. I want to calculate the time in the Concept Phase for the first project from that Concept (the Approved Gate 0 UID), but mark it N/A for any subsequent references to that UID. I figured out the formula below…
How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.