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]
Options
joeybenjy
✭✭
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
Comments
-
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
This discussion has been closed.