-
How to use Trend Arrows to show change in RYG
Is there a formula that would highlight the trend of a change in RYG balls ? For example, if someone changes the status of a project from Green to Red, it would show a down arrow. If someone changes the arrow from Red to Yellow, it would show a Upward arrow. Thanks for your help!
-
Question on multiple predecessors
Hello! When using 2 predessors for one row, smartsheet calculates the later start date. How can I manage to get the earlier start date. For me it sounds like a common requirement. Start as early as necessary to meet 2 alternative deadlines ... Kind regards Michael
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Auto move column info
I'll try to explain the best I can. I have a customer who will view only a summary sheet in Smartsheet. This info is pulling from various cells in individual Smartsheet store pages that they cannot see. This summary is set up in a "One store per Column" arrangement. As the store page info is populated, various info…
-
Gantt chart, how to color weekends in OTHER colour than grey?
I have seen some post regarding the possibility of changing the colour of the columns marked as "non working days" and all suggestions to solve this seems to point to the possibility to change the colour of rows. So, I am again asking about the possibility to change the the colour of columns to enhance the readability of…
-
Submitted Web Form - User Information
We are creating a web form to track business development possibilities. Other than adding a "Your Name" field to our web form, is there a way to see who submitted the form? On a current smartsheet where we are using a web form, I can right-click to view history, but it shows only "web form user". What we would like to see…
-
Sheet automatically scrolling across as soon as I place mouse in sheet.
I have one sheet (that is shared) that automatically scrolls across to the right of the screen as soon as I place my mouse in it. I can not manually correct it back to centre or to the left of teh screen so i can read the data in it. My other sheets are not affected, and are working fine. Can you please recomend a remiedy.
-
Working with Multiple Calendars, Vacation Days, and Weekend working days
In my project team, we have team members located in different parts of the globe. I need to link to the project non-US calendars and holidays aside from those of the US. Additionally, I need to enter the vacation days of all team members who has vacation plans or out days, and enter weekend working days when, say, a…
-
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 =…
-
effort and allocation-based timelines?
We have a small team, with each member having very a specific area of expertise. As such, our timelines are defined by prioritization of tasks, dependencies, effort, and resource allocation. I want to enter my tasks, set their dependencies, effort in hours, priorities, plug in the resources and set their allocation, and…
