Attempting to use SumIfs where 1 column could have multiple different values.
Hello! 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 a column based on the values in 2 other columns. my column headers are: Sprint, Task Hours,…
Formula for a new Sight
I 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 of the days taken to complete it. In simple words, I have two columns 1. Management…
DataMesh User Guide / Training
Hi, Are there any user guides or training videos on how to use Smartsheet DataMesh? Thanks
PMO Use of Smartsheet
Hi, 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!
The 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 is black while indicating it's red. Perhaps it's minutiae, and the details sometimes…
Forms in a Template
I 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, so when I create a new sheet from that same template the form no longer carries over…
count decision formula
Hi 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
Is 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 chart
Hi I am wanting to display the FY weeks in Gantt view, not Fiscal year. Is there a way of doing this?
Automate RYG (percentages)
Hi 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 formula, but is not working, any other thoughts around this? =IF([%…