-
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
Hi, I am working on a project wherein a 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,…
-
Report showing different color than the row in the sheet
Hi - I have a report that I run that shows me all the line items from various sheets that are assigned to me. On the report is a column for "Sheet Name". When I run the report, all of the rows from one of my sheets looks the same - the value for Sheet Name shows with a white background and a blue link that I can click on…
-
Monthly Calendar View Exportable to a PDF?
Hi there, I have a large Smartsheet document that I would like to export to a PDF. While I can export it under the card view, regular view, and gantt chart view, I cannot export it with the monthly calendar view. Is it possible to export the monthly calendar view into a PDF or Excel sheet? Thank you!
-
Resourcing Allocations
I am trying to find a way to accurately reflect the resource capacity of an individual when assign multiple concurrent tasks in a single day. I appears that if I assign for example 8 one hour tasks (effort = 1h) that the person shows up at 800% capacity for that day rather than being at 100%. How can I make this work? Do I…
-
SubTotal
Is there some way to use subtotal with filters like in Excel ?
