-
Best/Good Practice request: True up miscellaneous tasks
Looking for better practices than what I am currently doing. Example: On Tuesday, I expect to get something from the vendor. Usually that means end of day for planning purposes. I put that in the schedule as either a milestone (0 duration) or a full day task. On Wednesday, Admin Albert needs to spend less than 2 hours on…
-
Formula to include new data added to my sheet
I have set up a formula that works very well however it isn't taking into account new entries added to my sheet. For example my formula is on Row 1 under the column 'total' I then have other information in rows 2-15 so therefore my formula on Row 1 starts from row 16 to give me the total I want into Row 1. My formula in…
-
Combining formulas for child rows
I have an easy formula to work out the average data entered into my child rows, the formula is as follows: =AVG(CHILDREN()), this gives me the average of all data put into the child rows perfectly. However, if nothing is entered into these child rows the parent row with the formula in it just shows #DIVIDE BY ZERO. I would…
-
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
