-
Managing Active Documents in Smartsheet
When it comes to editing a document that is stored in Smartsheet, I'm looking for the best way to manage active documents (e.g. word template that needs to be edited on a continual basis). It is a huge pain to have to save it somewhere else, edit it, then delete the old doc in Smartsheet and upload the edited one. Please…
-
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…
-
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,
-
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…
-
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?
-
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…
-
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
-
Report to show all Project Managers without duplicates
Trying to create a simple report that will list all project managers from (3) sheets without duplicates. I can get the report to give me all the project manager names without any issues. The problem I have is it showed duplicate rows of the same project manager. I would be ok with a single project manager name entry with…
-
User download@smartsheet.com in the Activity Log
Hello community and/or Support Could not find in in the helpfile: What / who is the user download@smartsheet.com in the Activity Log (see attached screenshot) ? I first thought It is actually the user who downloads the attachment, but when I do this, the Activity Log is not updated whith this action. Maaik
-
Enhancement Request: Show info for files attached from Dropbox (and likely others)
When a file is attached from Dropbox (and assume the others, haven't tested), the date it was attached is shown in the Attachments dialog. According to the API, this is the "CreatedAt" timestamp. What my customer would like is to show the modified timestamp from the file itself, as the documents won't be static instances,…
