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.
Archived 2017 Posts
Archives for August 2017
Discussion List
-
Attempting to use SumIfs where 1 column could have multiple different values.In Archived 2017 PostsHello! I have tried to find the answer by browsing through questions already submitted about sumifs but I can't seem to find a question that addresses my issue. Apologies if this has been asked and answered. I'm attempting to sum…
-
Formula for a new SightIn Archived 2017 PostsI want to find out the min, max and avg days taken to complete a project. We have around 68 management systems. So, how can I put a condition for say ABC system was used in 6 projects (from its column) and find out the min, max and avg…
-
DataMesh User Guide / TrainingIn Archived 2017 PostsHi, Are there any user guides or training videos on how to use Smartsheet DataMesh? Thanks
-
PMO Use of SmartsheetIn Archived 2017 PostsHi, Has anyone successfully used Smartsheet for a portfolio of projects? In particular, we are being asked to track dependencies between projects and to be able to produce a high level gantt chart across multiple projects. Thanks!
-
Forms customizationIn Archived 2017 PostsThe required field indicator is a red asterisk. When we built a form, we mentioned that anything with a red asterisk is required - but we can't customize any of the text (including the asterisk) in the description. So the referred asterisk…
-
Forms in a TemplateIn Archived 2017 PostsI have been successfully using a template to create project plans with a form. I've created dozens of sheets from the template with no problem having the form transfer from the template to the new sheet. This morning that stopped working,…
-
count decision formulaIn Archived 2017 PostsHi all I have a sheet that using the decision symbols, can anyone help me with the formula that counts the number of Yes, No, Hold. I would be happy if there was a way of just counting the number of the green yes Many thanks
-
Color PalletIn Archived 2017 PostsIs it possible to have a wider range of colors to choose from within the color pallet? When making gantt charts it seems I am limited a bit too much.
-
Financial Year - Weeks view in Gantt chartIn Archived 2017 PostsHi I am wanting to display the FY weeks in Gantt view, not Fiscal year. Is there a way of doing this?
-
Automate RYG (percentages)In Archived 2017 PostsHi everyone, probably more of the same, but I cannot make my formula work... what I want is to change the color according to percentages in a different column, 0%to 33% Red, 34%to66%Yellow and 67% to 100% turn to green. I have used this …