-
Parent Rows
Is there a way to remove the Start Date, End Date, and Duration from a parent row without Disabling Dependencies? We have an Alert set for the day after a due date in a column that has an unchecked Complete box. We are receiving alerts for our Parent columns which are not actual tasks. We could add a condition that the row…
-
RYGB Formula
I'm trying to get a RYGB formula to work. I'm thinking my order is wrong but I'm not sure. I had it working for RYGG but was asked to show Completed Tasks in a different color. I would like to change this so that Blue = Complete and N/A and Not Started are blank. Formula that is currently working for RYGG: =IF(Status@row =…
-
Dependencies & Predecessor Dates
Hello, I am having trouble with predecessor dates. I would like the duration and dates to be set automatically for line 10 as Rows 9 and Rows 17 change to accommodate variables. I'd like the date to load as one day after the Finish Date of row 9, and end one day before the begin date of row 17. It isn't working out that…
-
Crosssheet Countifs using Date and OR
Counting data from another sheet: Need instances of Class , if, Date is >= Start date, Date is <= End date, Class needs to ="Webinar: AGM", "Webinar: Hybrid", "Webinar: ToolBox", or Webinar: Objections" Columns = {Class} and {Date2} Cell References= [Start Date]1 and [End Date]1 Formula says invalid operation.…
-
Dashboards - Public Access
I want to be able to share a dashboard company-wide that I have created and make it more than "view only". The dashboard contains 3 forms I want any company user to be able to interact with (without me individually sharing it to each user). How do I accomplish this? Currently, publishing it has only allowed users "view…
-
Request Approvals
Hello All, We are creating a time off/work from home request sheet for our Director of Operations. We have been testing the sheet and it's notifications and noticed each time a request is approved, the D.O. receives an email. We tried changing the settings so that the alert was set for when a row is added not when a row is…
-
pivot tables are not updating graphs
i have set pivot tables to refresh immediately but they are not auto refreshing when data is added manually to a sheet or via a form. Only way i get them to refresh is to manually go in to each pivot table and refresh
-
Problems with conditional formatting
Hi, I am trying to apply conditional formatting to a cell if it is blank. The issue I am having is that the cells I want to apply this to have a formula in them (=IF(Name16 <> "XXX", "N/A", ""). The conditional formatting doesn't pick up the "" as being blank. Have tried a few workarounds but haven't found a solution that…
-
Using SmartSheet for Discussions/Messages/Threads
Hello! We've been using SmartSheet for the last ~9 months and love many of its features (e.g. project plans, Risk, Actions, and Issue Logs, etc). One use case that we haven't been able to find a great solution for, however, is basecamp like message boards/discussions (https://basecamp.com/features#message-boards). How have…
-
Legends on Calendar
Is it was possible to add a color legard on the calendar view? I noticed someone else asked a year ago and wondering if maybe Smartsheet made this possible. See screenshot.