-
Auto-Complete
Hi, How do I enable auto-complete in SmartSheet? I am designing a form for linguists to borrow items for fieldwork, and it would be great if their name, e-mail address, fieldwork location etc. came up as an option when they started typing in a cell. Thanks, Jen
-
Cell Linking - Discussions
Enhancement request: It would be nice to be able to cell link the discussions on a specific row. I know the workaround is using Reports; however, I want to build another sheet that would link to a source sheet.
-
How to enter a foot mark?
I have a field I enter either the inch mark into ( " ) - that works, but when I enter a single mark, for foot, as in 3 ' x 3 ' - a measurement, where the foot mark is the ONLY thing in the column it just goes to blank instead of retaining that one character.
-
Tagging Smartsheet rows
I am planning to add a Dropdown List column to each of my Smartsheets with the column name Tags. Before doing so, I thought I would check with the Smartsheet Community to see if people have done anything like this. I will be using the tags in reports serving as to-do lists, starting first with the Getting Things Done (GTD)…
-
Indent Copied Tasks isn't working
Hi all! I'm copying a large number of tasks and have pasted them where I want them. Only problem is, they got outdented as far as they can go, and the indent button is greyed out when I select them for intention. Any clue why this is happening?
-
Help with Sites and Sheets
I'm struggling to create two things in my Smartsheet. I'd like to have a countdown in the completation date from "today" until our project's expected final day. And capturing the %done of the project in smartsheet, maybe I'm doing something wrong but the =AVG() is not working for me. I'd like the program health to indicate…
-
Text/Number column is editing my number
I input the number 2800.06610 and Smartsheet edits my number to 2800.0661 which means it is eliminating the zero. This column does not have any conditional formating. What am I doing wrong?
-
Lock a Sheet/Tab on main view
Not sure if this was a previous discussion item, but wondering if there is a way to lock a specific sheet to always show up in your main SS page when opening.? I made the sheet a "Favorite" but it always seems to get closed
-
Hiding a column using conditional formatting feature
I am in the process of creating a survey for my work place. The survey questions are all yes/no questions. These questions take form of their own individual columns on the spreadsheet. Some of the questions have nested follow-up questions, with responses being children to a primary parent question. For example: " Do you…
-
Formula to calculate the next Friday after today
I have the formula below in Excel that calculates the next friday from today's date; so that any time the sheet is opened before a friday it will automatically insert the date for the coming friday, and when that date has passed and the sheet is re opened it will automatically insert the next fridays date in the week…
