-
Tabs No Longer Showing
Sometime last week I noticed my view in Smartsheet (using Chrome) no longer has the tabs at the top of all of the current open sheets. How can I get this view back? It was much more efficient than the pinning option we have now. Also, the recently reviewed Smartsheets would be great if it actually filled up that column but…
-
Exclusion Formula for Sum/Count
I am trying to get a total of my "Forecasted Amount" column which should include the following stages "0-Lead"+"2 - Qualified"+"3 - Proposal"+ "4 - Final (EL)"+"5 - Win". Currenly I have it set up to only not include the "6 - Lost" with this formula: =SUMIFS(CHILDREN([Forecasted Amount]52), CHILDREN([Referral…
-
Reference Cells That Start With Specific Numbers
I would like to write a COUNTIFS statement that will count the number of cells that begin with certain numbers in a column. The goal for this is to be able to count cells that are between certain times of day, so I would like it to be able count the cells that begin with "1:, 2:, 3:, 4:, 5:" and a separate one for other…
-
Reference a column in another sheet
Hello - My company is new to smartsheets but it has ALREADY made a huge difference for us. I'm playing with functions that reference other sheets and I have a very specific question - I'd like to sum all of a column IF two conditions are met: the dates match and the payment type is the same. The formula I'm working looks…
-
Linking Epics Across Sprints
Hello Community, I'm trying to rollup epics and themes that exist across multiple Sprints in my smartsheet. I've created parent and child relationships from a Phase level. I may have my parent-child relationships incorrect. Please take a look at my screenshot. Any help would be much appreciated. I'm trying to roll up %…
-
Building custom actions
I need to continue some training in setting up actions from one sheet to another. I can use the pro-desk to set up a 30 minute training session but can't remember how to get the code to type in for a new request. Thanks, Dennis
-
Sum of work log between a date range for given list of users
Hello, I really need some help on this. I have two sheets one with user work log information with dates and user name. Now I want to add the efforts for a given date range and for a particular/all users. I tried summits but not able to come up with anything as it is always giving mw wither 0 or invalid argument. I tried…
-
How do i add more than one duration to a gantt chart?
I have a project that has hundreds of tasks. Each task has a fabrication duration and a delivery/logistics duration. How can i add an extra column and add the extra duration per task to show in the gantt chart in maybe a different shade or different color? The other solution, would be to add a line below each task just for…
-
Contact Columns marked Multiple Don't Populate Legacy Reports
I have 140 or so projects I manage reporting on and was excited to see that we could now do multiple contacts in our Assigned To column. However, when adding new projects with this feature enabled I noticed that Reports count those columns as different than other Assigned To columns without this feature enabled even though…
-
Dashboard Color
Any plans in the future for letting us update the dashboard background color to any color we'd like? I'd love to be able to use black for dashboard backgrounds, as well as the backgrounds of the widgets, so that when on TV sets around the office, graphs are floating in black instead of a white background.
