- 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…
- Assigning Team Memebers to Task/Duration
Let say you have a task with a set duration, start and end date. The duration was based on 1 person doing the work but if I want to assign it to 4 people so it theoretically goes 4 times faster. Is there a way to say to smartsheet "This task has 4 people working on it" and for smartsheet to then adjust the duration, start…
- Helpful if Date format has letters in it
嗨,我是工作在一个项目中part of the development team in India and other part in the US. I initially had my Language (Country) setting as "English (India)", but this date format caused confusion for the team which are in the US, since it is based on dd/mm/yy whereas the US is used to mm/dd/yy. For example,…
