-
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.
-
An error has occurred in the application. Please log out and log back into the application before c
Hi There We have call Smart sheet a number of time, left about 5 messages and still waiting on a reply I have also emailed as seen below. Regards Jacqueline Niemand Hi there, We Emailed over 10 hours ago and it’s still coming up with the following error we have loss a whole day with a number of staff not being able to done…
-
How to Setup Formulas to Automatically Link & Pull Data from Other Sheets
I'd like to try and figure out how to most effectively and efficiently connect 2 separate smartsheets together, preferably through some sort of smart formula/code. I don't think doing a manual "cell linking" from a cell in one sheet to the next would be very smart or efficient for what I'm trying to do here. I have both a…
-
Date Created System Column not updating if NOT using webform
I am modifying the "Help Desk Ticket Tracker & Form" template. I don't want to double-enter the date, so I deleted the 'date' column and am using the 'Created (date)' system-generated column. When I use the webform, it will fill in the date created. But if I add a line directly in the smartsheet, it leaves the Created date…
-
Change Column Name in Multiple Sheets
Is there a method to change column names in multiple sheets? (I'm aware of the impact on reports that include those sheets.) It is very labor-intensive to change the column names in multiple sheets, but that is how we work in the real world. Change, change, change. I've already updated the template, but wow what a pain to…
