-
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 %…
-
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-…
-
Automatically send latest attachment
I would like to be able to set something up that, when a field is checked, the latest attachment (or at least a link to the attaschents for that row) gets sent to "contact in column"
-
Gantt Chart Formatting Gaps
Hey, I have been making some project programmes for my boss to present and there are occasional (seemingly random) lines running down the gantt chart. Some are at the end of a week some are at the start of the week, they are all of different widths. When the chart is exported and printed it is very distracting and I don't…
-
Editing an email sent from a row
I was wondering if there is a way to have someone edit a field when you just send a row to someone. What I mean by this is would be the person receiving the email able to check completed or update a date from just the email rather than sending someone an update request?
-
Unsubscribe from email alerts
Does anyone know what actually happens if a user selects the unsubscribe option when they receive an email alert? Many of our alerts are not necessarily optional I don't want users to be able to just opt out of them at will. I selected this on one myself to see what happens, but I can't find anywhere on my sheets or the…
-
Is there a way to re-designate the primary column after a Smartsheet has been developed and populate
I would like to switch the information that is displayed in the calendar view to data that is present in another column within my sheet.
-
Creating an automatic Change Order
I was wondering if there is a way to create a change order in a smartsheet so we do not have the type everything out and it will auto populate pricing?
-
Importing Spreadsheets with Vlookup from Excel
Is it possible to import a spreadsheet (with a few sheets in it) which has Vlookup and other formulas? Doesnt anyone has done it? I have just signed in for a free trial... it looks like I have to do all the hard work again in terms of formulas (in special Vlookup)... if so, see little benefit in using this. regards, Jandir
-
Can I set up a report to auto run?
Hi there, I have a report set up with all of our bidding projects. Every week I go in, change the date to dates greater than "today", then click "Run" so it'll only populate future bids. But now I'd like for it to automatically refresh with "today's" date every day. This way I can have it displayed on a dashboard. Is there…
