-
How to show a percentage in a cell with text mixed with formula
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) / 3 Result: 25% However if I add text to the front of the formula, the result changes back to an integer: Formula: ="Progress…
-
Sprint Name field
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.
-
one time change cell
Hi, There I would like to know if It is possible to freeze a column one's validation is given to make sure no more modification can be done. Thank you,
-
Invite showing as expired when clicking accept
Just setting up our account and sent out the first batch invite to our users. I am getting a high number that are saying when they click accept it comes back saying the invite has expired. See attached file for exact message. Have tried to resend to the individuals but still the same issue? Any one else run into this? VPN…
-
Resource Allocation
So we have some re-occuring projects sheets that are used like check list. example: * Board Meeting* Put out Name Tags * Confirm Tech Times * Check AV Equipment And a lot of time they are all assigned to one person. We know that we can assign the value to these tasks a percent that is low, but is there a way to set…
-
Free Collaborators vs Non Licensed Users
Can someone explain the difference between a non licensed user and a free collaborator? e.g. * Do they need a smartsheet account? * What can and can't they do?
-
Set a dropdown value for all selected cells
For nested items especially, it would be nice to select multiple rows' dropdown cells, right click, and set a dropdown value across all those that are selected. So, 5 nested rows whose parent's dropdown for "status" is set to "complete". I'd like to be able to select cells from that same column for the nested rows and…
-
Auto Delete
Any time I click on a cell in SmartSheet and leave the cursor on that cell for more than 5 seconds it is automatically deleting the contents of the cell. Any ideas how to stop this?
-
Do not allow data if cell is unchecked
Hi, Is there a way to format a column so that it should only allow contents to be entered if a specific checkbox is checked? For example: if column A checkbox is unchecked, I cannot enter a date in column B (text should be allowed). Thanks, Dina
-
If(And( Greater Than Less Than)
I am having trouble with the following formula: =IF(AND(Percent1 > 0, Percent1 < 6), "Scope", IF(AND(Percent1 > 5, Percent1 < 11), "AE Selection", IF(AND(Percent1 > 10, Percent1 < 21), "Design", IF(AND(Percent1 > 20, Percent1 < 26), "Bid", IF(AND(Percent1 > 25, Percent1 < 96), "Construction", IF(AND(Percent1 > 95, Percent1…