-
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,…
-
alter working time
How do I restrict the working time to week days, I don't want the bars to go through the weekends
-
Task Duration - Partial day at beginning of period, not the end
Hi, I notice when you add a half day duration to a task, it places the half day at the end of the period, for example a start date of 13/11/17 (Monday) with a duration of 2.5 days will result in the half day being on the Wednesday. Is it possible to make the half day on the Monday and the full day on the Wednesday? I'm…
