Use system column in gantt view

Hi folks,

I remember there was a way to use a system column (auto creation date, for example) in the gantt view...the trick was to create another date column and use the =created2 (or the number of the row).... but it will not work (smartsheet will transform the formula in text). I tried the same formula in a normal number/text column and I got this : #INVALID COLUMN VALUE

Any ideas?

Find more posts tagged with

Gantt View

Comments

Chris McKay

Hi valentink,

If I'm reading what you're trying to do and what you've experienced correctly, you want to use the Created (system column) date as a component of your Start or Finish date in a project plan and plot the results on a Gantt. Is that correct?

If so, you're out of luck. When you allocate particular columns to Start date or End date in Project Settings, Smartsheet embeds hidden formulas in these columns to calculate values based on predecessors, duration etc.

Any formulas you enter in these columns will be converted to text (if they aren't in a date format).

valentink

Yes this was the goal. The part I don't understand is that I used to do that (last year). I was using a column that was simply linking (=) to a system date, since there was no way of using the system column directly.

That way I had a gantt chart of all my tasks with then they started and when they were done (in my case, last modified)

I guess this option doesn't work anymore

valentink

OK SOLVED!

The problem was that my column that was referring to the date of the auto system column was already used by the gantt chart!

If you have the same problem, make sure that your column is not used by the gantt chart

Sign in to join the conversation!

Quick Links

Trending discussions

Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
License Question
I already have a Smartsheet license with my company, but I was recently invited to collaborate on a sheet owned by another group within the same organization. When I accepted, I was told I need to upgrade in order to edit or contribute. Can you please explain why this is required? It seems unreasonable to need multiple…