-
Adding checklists to a project
In my project with gant chartsd and ependencies, I would like to add a task, e.g., "Set Up Vendors". As a subtask, I would like be able to add 10 vendors. Ideally then, as each vendor is setup, I want to "checkmark" each vendor. Once all 10 vendors are checked, then the task can be marked as complete. Is this possible?…
-
Notification emails going to additional wrong people
I have a sheet with conditional check boxes based on who is selected in a dropdown list. Notifications are set for the relevant person to receive an email when the box is automatically checked. All entries are made by a web form. Problem is that SS is sending the notification to additional people (from the drop down list)…
-
Is the site down?
Looks like this is the second time in a month there's been unscheduled maintenance.
-
Parent Date Roll ups - Possible for two sets of dates?
I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…
-
Internet connection or maintenance?
Hello. For some reason, one of my pages doesn't allow me to save, saying "Unable to reach Smartsheet.com. Please check your internet connection." However, I have another tab open to a different page in Smartsheet that allow me to save with no issues. Has anyone experience this/know how to remedy it? I've signed out/back…
-
Report for when a column has been modified in last X days?
Hi all, starting with a sheet that includes all marketing tactics for all of our projects, I'd like to build a report that rolls up every row that has had column "Designer" modified in the last X days. Is that possible? I can't figure out how to do so. I cannot add any formulas or conditional formatting to the master sheet…
-
Freezing Column Headings for Reports embedded in Sights
Hi there Are there any plans (or was anybody successful) on the topic of freezing column headings in reports. In particular when the report is embedded in a Sight? Thanks for your advice. Regards jan
-
Sum Children() If Date <=today()
I'm trying to create a fomula that will sum the TOTALS column for all the Children() of a parent row that the DATE <=Today(). Any thoughts?
-
SUMIF not working properly
I am trying to create some summary totals on an inventory sheet. We stock several model Laserjet printers. Each row has it's own sum. Now I'm trying to create an overall sum of Laserjets by using the following formula: =SUMIF([Inventory Item]1:[Inventory Item]86, "Laserjet", [In Stock]1:[In Stock]86) If I interpret how…
-
Changes By Multi Users
HI, Cna you please confirm how one can view the changes made by other users, if that is a shared workbook? How one user will know that second or third user is working on same row/column so he avoids going to those cells? Regards,