-
Formula to show monthly count
Hi, I am trying to figure out a formula that tells me how many entries have been entered for a particular month. I have a date column and an tonnage column so if I have 10tonne of material made on 1st February i would enter in the date column 01/02/16 and next to it in the tonnage column I would enter 10. I also have a…
-
Summary Tasks Show in Google Calendar
Even if I uncheck "Display Summary Tasks" on the Calendar settings, Google Calendar shows the summary tasks from my smartsheet. Is there a way to prevent these summary tasks from syncing to Google? Thanks for any help! Best, Max
-
Unable to import a CSV column as Text/Numeric as automates to Drop Down List
I want to create new sheets from CSV or excel data to create a new Smartsheet chart with a project layout and then create a gantt chart. I can achieve all that but the column for Duration insists on creating a "Drop Down List" type which I have to manualy convert to "Text/Number" before turning on the GANTT chart. This is…
-
Excluding indented rows from being auto-numbered
I am using a web form for users to intitate developent requests and have set up column to auto-number each job request (P0001, P0002 etc.). The shop supervisor then adds rows below each job request to assign tasks to different team members and indents these under the main job request. Smartsheet assigns each indented row…
-
Best/Good Practice request: Resource Leveling
Another better practice looking for. How do you handle completed tasks and resource leveling? If there is a 8 hour task scheduled for this week and the person knocks if off on Tuesday, they aren't needed on Wed-Fri at 20%. For long term planning, I'd really like to know the task took 8 hours and that the person did it in…
-
Remove Parent Row from Calendar
Is there a way to remove the parent row or hide it from the calendar? I am working on a project sheet for a group with many workstreams. The parent row is the title of the workstream and I would prefer if the workstream did not show up on the calendar. It takes up too much space and it will not allow me to color code it on…
-
Signature in Smartsheet
Is it possible to add a signature in my Personal Settings that I will have automatic signature in all my mails from smartsheet, even when I'n sending rows to somebody. Kind Regards, Ivan
-
How to count different status from one column
Dear all! In our projects we use smartsheet as data base for elements of decor. At the moment we have four different statuses on each elements. In this case would like automatically count all red, blue, yellow and green statuses and see how many elements we have on different production stage. I know how to coun all…
-
Average % complete if task is assigned to "xxx"
What I am trying to do is figure out an assigned user's bandwidth. I am doing this by having them assign a % Complete to a task and then averaging the children =AVG(CHILDREN()). What I want to be able to do is average the children but only for specific assigned users. So average the children (% Complete) for tasks assigned…
-
Improving the context of answers to community questions
Hi all, can I suggest that as there are lots of new users to the community since it was launched only a few months ago, that existing and new members add a little detail about themselves? That extra info should make it easier to see the context in which a question is being framed, so the answer is more appropriate?…
