-
Content from Engage 2019 Keynote speech
I am working on a presentation for our exec team about my experience out at Engage 2019. Does anyone remember the name of the company that spoke during the keynote speech about how they used Smartsheet to get resources organized & on the ground faster during Hurricane Dorian?
-
Conditional Formatting
Is there a way to use conditional Formatting in a row and not just a column? As you can see in the attached photo I have different Benchmark numbers set up per row, If I set up conditional formatting it only lets me set up one value for my sheet if that makes since!???
-
Unparseable Error
When I leave my sheet, a column becomes #unparseable, however it works when I log back into the sheet. Any ideas as to why?
-
Two instances of Smartsheet for the same organisation
Hi Community, For several reasons, we need to have two separate instances of Smartsheet in the same organisation. Some have only access to one and other may have access to both instances. They will have to use the same login email in both instances. I remember that in the past, this gave us troubles. Staff could not…
-
Export Gantt Chart - wrong start point in overview
Hello, everyone, I would like to export a project plan as a Gantt chart in a year and quarter view. When I set these options, different entries are in the wrong quarter. Is anyone aware of this phenomenon or does anyone know how I can correct it? Endpoint is in Q4 2019 but it reaches Q1 2020..The dates are correctly set in…
-
New comments functionality.
Plain and simple its awful. Actually, to a large degree unusable by our employees and external customers. 1. forced ascending order. does not work for us at all. 2. hitting return on your keyboard - posts the comments. super annoying. 3. "All" comments view. No idea how anyone thought this would be useful. Its confusing…
-
Return 1st column value if 2nd and 3rd column is blank
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
-
Master Sheet with Subprojects Inside
Hi! I am trying to create a Master Project sheet that would include subprojects inside of the same sheet. Basically so I can track the dates and overlapping of tasks in the subprojects. Is this something that Smartsheets can do? I know I can do it in MS Project and just add each subproject as it's own task in a master…
-
Need help with "IF" formula
I am unable to get the formula right for the following scenario: Column 1: Yes / No Column 2: Yes / No If Column 1 and/or Column 2 is blank, then "Not Completed" If Column 1 and Column 2 is Yes, then "Completed" If Column 1 is Yes, Column 2 is No, then "In Progress" If Column 1 is No, Column 2 is Yes, then "KIV"…
-
Double Brackets not working on Send Email?
I am attempting to use the 'Send Email' function and including fields in the email subject and body. I have attempted using the double handle bars but am not seeing the expected results. Any suggestions on what I may be missing?