-
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!
-
RACI Template
Hoping someone can help steer my in the right direction! IN the project managemet tools there is mention of an RACI template however when I log in it does not seem to be there? Am I looking in the wrong area or is this some secret enterrise level only template... Thanks Nik
-
Slow Reaction time
Hi. the reaction time is PAINFULLY SLOW. My sheet is only 120 rows by 35 colums. 21 of the columns have formulas in them. Other than that there is nothing. Not all colums are filled in. Is there a tweek or trick I can apply. If I move too fast it also freezes up. this is going to highly irritate co-workers. Help? LE
-
SUM Function is not working properly
Hey Everyone, I'm currently working in an area where my SUM formula is simply not working, my formula is =SUM(ColumnB127:ColumnB133) and it continues to return a value of 25. Below I have provided a picture. I even thought it may have something to do with the value's being linked, and pulled those values into a separate…
-
Sum formula Error When References Results from IF Formula
I am getting an #Invalid Operation error when my Sum formula references a cell with results from an IF formula: =SUM([Column 8]1 * [Column 9]1) results as #Invalid Operation error Column 9 formula =IF([Column 2] = "A", "0.5%", IF([Column 2] = "B", "1.5%")) I've tried to fix by using a nested VALUE= but that does not work…
-
Multiple selections
Is there a way to create a multiple selection option in a column? Was considering Checkboxes that could be linked to the selection by typing next to it or drop down options with ability to select multiple choices? Please let me know if anyone has created something like this or if there is an option to do something like…
-
Formulas looking up data from other sheets
Is it possible to create a formula in one sheet that looks up info from another sheet? I dont mean linking cells - I need to be able to set an IF statement based on the input of one column in another sheet. You can do this in excel so im wondering if Smartsheet also allows for this.