Changes since last week

Hello,

Is there a way to show changes since last week to a 'date' column? I don't want to highlight the change, I want to be able to see if the date moved since last week and then calculate the number of days it moved (eg: +10)

I don't want to right click and view cell history either. I want to show a simple report/project with columns showing 'Last week's date' , 'This week's date' and 'Variance'.

Find more posts tagged with

Accepted answers

Jennifer Greenough

Hi Jas,

We have run into similar situations where we want a baseline for our project schedules. Unless I've missed an update this is not functionality available at this point in Smartsheet. We have gotten around it in a couple of different ways:

Creating a copy of the given date column in your sheet as a baseline and then a variance column that calculates the difference.
Downloading a copy of the sheet into Excel and then using PQ to calculate variance (this works better if you need to do this weekly as you can have a copy of the sheet automatically emailed to you each week at a set day/time).

Would be happy to hear of other options from the community!

Also, if you would like to have baseline functionality added to Smartsheet please submit an enhancement request.

Jennifer

All comments

Jennifer Greenough

Hi Jas,

Creating a copy of the given date column in your sheet as a baseline and then a variance column that calculates the difference.
Downloading a copy of the sheet into Excel and then using PQ to calculate variance (this works better if you need to do this weekly as you can have a copy of the sheet automatically emailed to you each week at a set day/time).

Would be happy to hear of other options from the community!

Also, if you would like to have baseline functionality added to Smartsheet please submit an enhancement request.

Jennifer

Jas Condle

Thanks Jennifer, it's a lot of manual work but it's a work around. Thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.