-
"Red" traffic light disappeared
Hi there, I'm currently using a "Red/Yellow/Green" traffic light status in one of my sheets, with the colour that is displayed being based on certain criteria. I've just noticed that the "Red" symbol does not show when it should (it was working fine before; "yellow" & "green" are still working ok.) I have not changed the…
-
Predecessors and Formula's Error when I delete rows
I have a master sheet that has tasks for all types of projects and depending on the customer we sign, I will go through and delete the rows I no longer need. The issue is that my RYG (error: #BLOCKED) and Predecessors (error: #REF) error when I do this which means I then need to go back and correct them manually Is there…
-
Export to letter formatted document
Has anyone tried building a sheet that would have a presentation level, letter format when exported? I'm looking to build proposals within Smartsheet, then I could cell link that final/approved fee into my project tracking sheets for cost comparison etc. In Excel you would typically do this via cell merging etc, but that's…
-
Auto Formatting with New Row Entry (via Webform)
Scenerio: Row 1 and Row 2 have a Blue Background for all 6 Columns. I created a webform to add above these 2 rows for all 6 columns. When I submit the webform, the added row does not receive the lower background on it. This use to work, and now for some reason it is not. Let me know if anyone has any fix, thanks!
-
RACI Template
Hoping someone can help steer my in the right direction! IN the project managemet tools there is mention of an RACI template however when I log in it does not seem to be there? Am I looking in the wrong area or is this some secret enterrise level only template... Thanks Nik
-
Calendar view of all Projects, the resources assigned to the projects, and their associated allocati
We are looking for a way in SmartSheet to present all projects (ideally, can be sorted/filtered by workspace) and the resources assigned to each project, and the associated allocation in a calendar view. I have created a quick mock up of the presentation attached. No capability to do Reports in the required Calendar view.
-
Adding 30 or 60 days to a date based on another Cell Value
Greetings, I am trying to calculate either 30, or 60 days from a date, depending on the value of another cell. Example: Cell 1: Date Cell 2: $ Value of less than 50k or $ Value of $50k and up Cell 3: Date plus 30 or 60 days, depending on the value of Cell 2. Any ideas? Thanks!
-
Slow Response Time
Hi all, Is anyone else struggling with slow response times from Smartsheet. I have around 40 sheets that i work on, and 1 tab open. Even simple tasks like moving the mouse and clicking on a cell or an option is taking around 30 seconds to complete the action. I have tried this in empty sheets and still finding the issue so…
-
Missing Column Criteria from Report Builder
Hi, I have been working on a report builder for a number of sheets from varying projects to show specific items. Understanding that I need to have consistent column names across all sheets, I have gone through the trouble of formatting them all. My issue now is that when I go to the report builder and I want to add more…
-
Process mapping
Does anyone use a process mapping tool such as Visio or TaskMap that can integrate well with Smartsheet?
