Hello, I am trying to created a multiple if Statement. If column1 contains "Milestone 1" show "30% invoiced If column1 contains "Milestone 2" show 80% invoiced If column1 contains "Milestone 2" show 1…
I have a large project sheet with multiple people assigned to various tasks. I want to send out a weekly update request, but don't want to have to select each row for each different user, as these cha…
I would like to be able to use an array formula like Excel has so I can recreate my fee estimate sheets in Smartsheet. It does not appear like Smartsheet can do this. Can you please add this capabili…
How can I get the Sprint name field to pull from Jira to Smartsheets? The Sprint field is not showing up as a field in the Jira + Smartsheets connector for me to sync.
I have create a column to evaluate whether enough resources have been allocated to a task. It evaluates whether the percentage in the % Allocated column is equal to, greater than, or less than a secon…
Looking for a way to visualize my data in an easier way. Love how I can create trend lines for others to look at in Excel. Would love to have this feature in Smartsheet.
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemin…
Hi, I have a percentage complete cell which is working correctly when the following formula is used and the cell is set to show as a percentage: Formula: =SUM([Column5]24, [Column5]29, [Column5]33) / …