-
Formatting data in lower right corner
Hi, I have a very simple suggestion: Smartsheet should format the count, sum, and average in the lower right hand corner (when multiple cells of data are selected, see scn shot). It is very difficult to tell the sum of a large number without commas. Thank you, Max
-
Duration in a summary task show "hours" instead of "days"
I have a series of sub-tasks in minutes and hours but then the summary task shows the duration in days. It is frustrating to not be able to change that, is it possible or could that ability be added to change the duration display in summary tasks? Thank you, - Blake Chesley
-
Smartsheet Sorting
Hi, Is it possible to sort data without having it sort the first two rows of data because the first two rows of data are my column titles. My column titles are just repeats of the smartsheet column titles. Thanks! Kevin Au
-
SUM IF & LEFT @cell
I keep getting the result of 0 I am trying to sum a range if another column contains "Street Lighting" I have tried changing the text reference from the entire column, to particular range and adding the LEFT @cell with and without #(5) see below. =SUMIF(Team:Team, LEFT(="Street Lighting", [Days to respond]2:[Days to…
-
Linking a drop down cell to the workflow
I have a drop down status cell on my customer sheet. I would like the info in this cell to be linked to the Workflow sheet in the status cell for each customer. I have tried to go to the Workflow status cell for a customer and link in from the customer sheet, this works and when the customer sheet status cell is changed…
-
Vacation/Out of Office causes resource over allocation?
I hope someone can help me out here, or tell me how they approaches this :) In my department we have some issues when people are on a project and then going on vacation or out of office, it will show as if the person is 185% over allocated. (for example if it is 85% project and 100% vacation) Is there any workaround on…
-
First email sent as update request does not appear in activity log or in comments box
Is there a way to show the first request and attachments sent as part of a thread- so it can be tracked from the start. Does not see to appear in either the comments box or the activity log...or am I missing something?
-
HIPAA Policy Change
Hello! Originally, Smartsheet was set up as a HIPAA compliant item. Can anyone clarify when this changed and what justification caused this change? I have reached out to Smartsheet but they haven't gotten any feedback. Does anyone else know? Thanks!
-
Computing duration from a min and max column
I'd like to support a Min Duration and Max Duration, and then compute Duration as an average of the those two and be reflected in the Gantt Chart. Is it possible?
-
Auto Formatting with New Row Entry (via Webform)
Scenerio: Row 1 and Row 2 have a Blue Background for all 6 Columns. I created a webform to add above these 2 rows for all 6 columns. When I submit the webform, the added row does not receive the lower background on it. This use to work, and now for some reason it is not. Let me know if anyone has any fix, thanks!
