-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
edit rows and columns from web form
Hi, are there plans to add the feature to edit/update rows and columns through web form? it would have save me a lot of time if I could do that. thanks.
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
RYG Status Formula
We have two set of data that are required. Count column that is 0 until there is entry into one or all of the previous columns. This formula provides a count (this formula works fine) =IF(Series5 = 0, IF(COUNTIF([SKU 1]5:[SKU 15]5, "") = 0, 1, 0), 1) In the RYG column I have this Formula. =IF(Count5 = 0, "Green", IF(Count5…
-
Export to Google Calendar although no longer syncing from smartsheet
Question- We would like to export the calendar to Google Calendar. I am familiar with the publish feature but it appears that it will only create a new calendar and can't be added to an existing Google Calendar. 1. Is this correct? I would like to export all entries into Google Calendar but not have it synced, meaning if I…
-
Row sorting
I use smartsheet to keep track of project stages, I have 5 stages of the lifecycle all sorted by a different color. Is there a way to organize the rows so when that stage is reached, the row automatically moves to the bottom of the next section?
-
Not receiving notifications
Hello all... I am fairly new to Smartsheet and this Community but have come across my 1st issue. I have created a Smartsheet where multiple users will be entering data for items to be purchased through our Purchasing Dept. I have created a formula where, when the "Ordered By:" and "Ordered Date" are populated, the "Status…
-
Agendas in the meeting templates
Hi - I'm working in the agendas, and in the template, there's upcoming, past and new agenda submissions. In the dashboard, it has previous agendas and upcoming agendas... How do I get that to update to the next agenda? The first meeting I did is over, do I have to make a new form for the next meeting and link it, or can I…
-
Not receiving notifications
Hello everyone, I am fairly new to the Smartsheet app, as well as community. I am having issues with not receiving notifications, when a certain task (column) is populated. I have created a Smartsheet to order materials from outside vendors. There are to be multiple employees adding stuff to this sheet, and one or two…