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 …
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?
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 alw…
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 que…
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, a…
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 th…
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 …
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 on…
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 ca…
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 (e…
