-
Feature request OR if someone has a solution????
I'd like to see an ability for Conditional Formatting to either; - reduce a row height to (1 line of text) - hide a Row And ofcourse add Shading etc. etc..... Cheers C
-
Select "No Background" in conditional Formatting
I want to clear the background of a specific cell when it is set to a specific value. But when I do that with conditional formatting I get this error message when I select "No Background" If I select white as background or any other color, then click OK it works. Any idea if that is a glitch in the system or if that…
-
160 character limit in field (used for sms)
Is is possible to set a l60 character limit to a field? The reason for this is that we collect texts from users (mostly by web form) that we will use for sms, but usually they write more than 160 characters which leads to extra work.
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Manage time entries based on previous ones
Hello! The use case I am trying to enable is that when a user makes an entry it should not exceed a set cumulative time (eg 120 minutes). So user 1 enters 90 minutes, user 2 enters 40 minutes in the cell below it which exceeds the alloted time by 10 minutes. Can this trigger a warning or validation that prompts for a…
-
How do I format a column for phone numbers?
I would like to format all input numbers to have the same format (xxx) xxx-xxxx
-
Date format inconsistencies, US/UK
If you copy and paste US-format dates (mm/dd/yy) into a Smartsheet while your personal settings are English (UK) (and presumably other Anglophone options), the data will retain the US format for all dates below 13. Where the date is 13 or more, Smartsheet will automatically transpose the format to dd/mm/yy. This can be…
-
Show changes made in the last 24 hours (only)?
Is there a way to have a smartsheet highlight only those changes that have been made in the last n hours? I look for changes to one of our smartsheets every morning and copy them to another file. We have yellow change highlights turned on but I'm finding that they can remain there for days, making it hard to see only…
-
Removing Projects on an ongoing spreadsheet
Is there a way to have the projects on an ongoing spreadsheet be removed or moved to another location so the spreadsheet doesn't become cluttered?
-
Burn down
Hello, i would like to assign cost rates to different people and to auto calculate the burn rate for my projects. this information cannot be shared with the people that the prject are shared with. Is there a way to do this? thanks, kate