-
Smartsheet issues on 2/22/16
Is anyone else having issues with Smartsheet today? I am having difficulites logging in, some sheets are missing the Harvey Ball graphics, the "+" are not showing up on my parent tasks so I cannot view the child task and date columns are not providing the little calendar popup. I know my Smartsheet said that it would take…
-
Issues viewing Live Webinars
Hi all, I have been having issues viewing live webinars since the switch to the "GoToWebinar" format. I click the "join webinar" link that I receive via email and am brought to the webinar landing page. I can hear the audio (in real time) perfectly but my screen never refreshes so I miss out on the visual examples being…
-
Importing into a Project Sheet
Hello everyone, As a project manager/trainer, I have been instructing PMs to create projects schedules using the Project Sheet. This is because it includes not only dependencies, but the timeline option. However, if we want to import from MS Project or Excel using the Import function, it imports into a blank template,…
-
Sheet Size
I have sheets that vary in size but most lean to the larger size due to the amount of formulas in the sheet. I am looking to see if on average people are choosing to have more sheets and less size or less sheets and fill the sheets to the top. I have done alot of work to all of my sheets and some have had to be divided. If…
-
Tracking benefits for funders
We are wanting to use Smartsheet to track the benefits of our corporate funders so we can easily see who is taking advantage and who isn't ... and use it as a reminder to get them to take care of the benefits. We have about 8 - 10 benefits per vendor that needs to be tracked. Suggestions for which template would work best?…
-
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