Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

add [date](summary of projected days to [Number of days]

joeybenjy

joeybenjy ✭

11/08/17 edited 12/09/19 in Archived 2017 Posts

add [date](summary of projected days to [Number of days]

Is there a simple formula to this .

=[Site Walk Schedule Date]1+[Projection Totals days]6

=11/1120177.777

its adding the the date as a number instead of date 11/11/17 to 6

0 ·

Comments

CanadaJim ✭

11/09/17

Hi Joey.

Make sure your column type for [Site Walk Schedule Date] is "Date". It's probably set for Text/Number right now.

Regards,

Jim

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Rolling-up information from sheet and reports. Unable to group information.
I am creating a report that pulls data from sheets and one other report. The information rolls up fine from both the sheets and report but it does not allow me to group the information from the report. For example, I want to group by program and then sub-group by sub-project. I keep getting a "Blank" for the group and the…
Need Help with a Formula
I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow I've tried a few things but can't figure it out. Can anyone help?
Count the number of times a person's name appears in an "Assigned To" column
I currently use the below formula to count the number of times a name appears in the "Assigned To" column. The issue is that this column can have multiple names in the same cell, so I have to created a separate formula for every possible name combination. Is there a way to have a formula that looks for a name string and…