Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2015 Posts
Archives for November 2015
Discussion List
Duration setting end date based on 8 hour day, not 10
I changed the length of the work day to ten hours in the project settings. When I set the duration for a task to 1d, the end date changes to the next day. If I change the duration to .08d, the end date is the same day as the start date. Is this a limitation of the trial verison? thanks
How do you change/edit a name in your contact list?
I have entered a name into my contact list incorrectly. I can't find a way to edit the name and it won't let me add a new entry using the same e-mail address. Any suggestions?
Non-working days for the enterprise
Would like the ability to set non-working days for an enterprise, with the ability for individual smartsheets to opt-out.
budget projection based on schedule
hello, I am trying to find a way to create quarterly budget porjections based on estamates in a column and my gantt chart schedule. This will show the project sponsor how much funding he will need to secure based on how much work is being done in a period of time shown in the schedule. Thank you
COUNTIFS to ignore "#Missing or Invalid Paramaters"
hello, I have a column that use "Networkdays" to calcuate the "Start" and "End date" of a row. Example: Project Name: Start Date: End Date: Duration ----------------------------------------------------------------------------------------------------------------------------- Project A 11/16/2015 11/17/2015 2 Project B…
Skip Logic
I really like how easy the web form is to use but have to use Google forms for skip logic. Does anyone know a work around? If not, I would love to see it added!
Imported Contacts not 'syncing'
I imported an excel spreadsheet that has a column of names. The column was imported as text. I changed the column property to Contact list. As I add people to my account contacts, the rest of the cells in that column with the same name are not sync'ing (?). Smartsheet wants me to add another contact entry. Is there a way…
Invalid data type
Hi I hope someone can help with a very frustrating problem. I have a sheet which is used to calculate work progressed. It takes the number of checked items in a column and sums them using the COUNTIF formula "Actual formula is ="" + COUNTIF([240mm Term]5:[240mm Term]171, 1)" The cell underneath this take this value and…
Started new sheet. Power went out. All work is GONE. Any way to recover?
I'd just put in roughly 50 lines of tasks in a new sheet. Hadn't manually saved it, yet. Power blipped out for a few seconds. After everything loaded back up, EVERYTHING was gone from the sheet. I checked my Personal settings under Account. It was set to auto-save after 3-minutes of inactivity and also to auto-save when…
Spreadsheet with multiple tabs
I was maintaining an excel spreadsheet with multiple tabs, and some of the fields under these tabs were similar, when i would update this field in master tab, then it would populate the same informatoin on similar fields on rest of the tabs. I imported this excel spreadsheet in to smartsheet and it is importing only first…