-
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?
-
Sales/Support Hours
I am growing increasingly frustrated with not being able to get in touch with help early in the morning (east coast). What are the hours that sales and support work? I can't find it posted on the website anywhere. Having to wait until midday to get a hold of anyone is really a pain and causing delays for my organization.
-
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…
