-
Please advise on best way to set up a SS
-
Resource Allocation
Good Morning, 4/28/16 - OK, so I just started a new sheet and everything is working fine now... QUESTION is could my sheets become corupt somehow. This is the 3rd time I've had to re-creat a sheet to make things work again. When I am looking at my Resource Allocation it is showing I have myself over allocated on 2 days.…
-
Unable to Connect to Office 365 via Outlook App
Non Global addministartors are unable to Connect to Office 365 via the Outlook App. All users here have logon access to the O365 portal. Othe Outlook apps we are using login with now issues. Users are getting a pop screen stating ------------------------------------------ Sign In Sorry, but we're having trouble signing you…
-
Recurrence Task
Hello, I have a lot of recurrence task within a year. I know that Smartsheet doesn't have this template yet where we can put the starting/development/due date each month/week for a year. And also I've been exploring another option Smartsheet suggested for example: using IF formula, create days between, sending regular…
-
How to find the percentage complete for a project
Hi guys, I want to know the percentage complete for my project. I have 10 tasks below my parent. If 3 of the tasks are checked, I want the parent to say 30% completed. I am using the formula below to find out how many of the boxes are checked. I could replace the 1 with a 0 to find out the number unchecked. I could do a…
-
Curriculum Project Management
Hello, I recently became a curriculum manager and want to utilize Smartsheet to oversee the annual curriculum, the coordinators, and take on a project management role. Has anyone used smartsheet in a similar way and if so, do you have an example of what you're using? Do you have any tips for me as I get started? I…
-
how do i create a task with multiple durations/start/stop/start/stop structure?
Hello I have a task made up of multiple intervals, can smartsheet include these in the tasks/gannt? Example - task 'a' - start 28/4, finish 29/4, start (1) 2/5, finish (1) 4/5, start (2) 6/5, finish (2) 13/5 Thanks Alan Russell
-
smart change of column name
Hi, i need to change several column names in my smartsheet. I have entire workspace built around this sheet, using it as data source. I have multiple reports that show/filter on this column, and if i simply change the name, reports stop working. is there a smart way to update column name everywhere? or somehow get a list…
-
time based reports?
I'm sure what I'm looking to do is not that difficult, I just can't find a way to achieve it. What I have is a sheet that consists of quote amounts ($) that are relative to a quote date. What I want to do is to look at how many dollars we have quoted that are on quotes a month old, 2 months old, etc. Ideally this would be…
-
Data shuffled after I save
Hello all, I have a sheet shared with 7 people. Almost everytime I save there are multiple rows that are randomly shuffled into different spots on the sheet. I have no formulas or macros... I thought I would throw this out to the community, any ideas?
