I REALLY need a successors column, for the same reason that multiple people have listed in discussion threads.
1) is this an enhancement in the backlog?
2) when is this high priority feature going to be added?
We recently released a Successor Function so that you can use a formula to create a column like this, see: Two new PPM Functions: Successors and isCritical, available now!
is there a way i can message you for some help, found your profile on a separate issue but im unsure how to message you direct on here.
Thank you, I looked at the documentation and from what limited info is there, I'm not able to make it work yet. I downloaded the PMO Solution Template, and trying to add a column with this formula in that project plan. Is there any examples you can provide specifically with values in it related to that template?
Hi @Daniel Gill 97
If you have a question for the Community, please feel free to create one in the relevant Category from the top right "Ask a Question" button! I'd be happy to take a look and I'm sure our other Community members will be able to offer alternate advice as well.
However if you have a Smartsheet question that has sensitive data you need to share, I would recommend contacting the Support team (here) so you can ask your question via a private channel.
I hope that helps!
The Successors function just needs any cell within the current row to be referenced in order to bring back a list of all the successor row numbers. Since it's possible you may have multiple rows dependent on the current one, Successors should be within a JOIN function so you can identify how you want to separate the row values, like so:
=JOIN(SUCCESSORS([Task Name]@row), ",")
I used a comma in that example, but you could use a / symbol or -, etc.
Let me know if that helps!
Hi Genevie, Im getting "incorrect Argument" result
I think this is a very important function and should be included as a drop in option for columns
Can you post a screen capture of your sheet with the formula open like I have above? (But please block out sensitive data)
I have provided a dynamic view for my users to see content on-screen. However, I've been asked to provide a print option as well. Normally, I would export a report to PDF for 'clean' printing [that is, preserves layout and colours with pretty explanatory note in header]. However, I don't want my users to have access to the…
Hi, Does anyone know if there is a way to send an alert if the value in a cell changes by more than a certain percentage? So, if I have 100 in a cell (text/number) and the value changes by over 5%, I'd like to be able to send an alert. Thanks, Vince
I'm sure this is super simple but myself and a colleague could not figure it out. I have some very simple data I need graphed for a project: Not Started, In Progress, Complete and then % Complete using the total. The pie chart for the Not Started etc. comes out correct: But when I ask it to graph just % complete, it does…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.