Column Formulas not appearing on Gantt Chart
Hi everyone,
I have a column consisting of "expiration dates" and another set of dates called "extension dates" if an extension has been made. I have put the formula "=IF([Extension Approval Status]@row = "ENABLED", [Extension Date]@row)" in the "expiration date" column, If an extension has been made and has been approved, the "extension date" will replace the "expiration date".
However, when input the formula into a converted column formula, it gets rid of all previous expiration dates and does not let me pick the "expiration date" on the Gantt chart. It also does not allow new expiration dates to be recorded within the grid, when a new form has been submitted.
Is it this a bug or is there an explanation for this behaviour?
Is there any possibility for a solution.
Answers
-
Hi Sahand!
Just to check, I am assuming the columns are all "Date" columns correct?
ALso have you verified all the settings in your "Project Settings"
Joe Goetschel | Associate Director, Smartsheet
CrossCountry Consulting - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
-
Thank you for the reply,
Yes both columns are dates, apart from the "Expiration Approval Status" which has a dropdown option to either accept, reject or be pending.
What sections in project settings are you referring to?
Many thanks,
Sahand
-
Hi @Sahand
Apologies but just based on the description you provided, If the formula in your expiration date column is a column formula, it wont allow you to manually amend / overtype without changing it to a cell formula.
Generally you need separate columns to contain whatever data / info you need referenced in formulas or pulled back to the column formula.
As below red column is a column formula and can only run the formula so you need to make amends in other columns so the formula can then pull through the info you want it to.
Formula in the master date column is
=IF([Extension Approval Status]@row = "ENABLED", [Extension date]@row, [Expiration date]@row)
Something to keep in mind when using column formulas, hope that helps
Apologies if this doesn't relate to your issue, it just seemed to by the description.
Thanks
Paul
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!