-
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…
-
Release Notes Link hard to find
Shaine, I was able to preview the formula Help and Activity Log prior to the release. Really liking the Activity Log for a sheet we recently rolled out that has over 500 users updating it. I'll have to spend more time on the formulas to give feedback. I did notice that the Release…
-
Some of my parent rows are grey background, some are not...
Hi, I'm trying to figure out why some of my parent background are grey, and some are not. In the page: https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows about 1/2 way down, under "Expanding and collapsing.." both "Administration" and "software engineers" parent rows are grey background. But in…
-
Auto-save no worky?
I've set the auto-save to 3 min. of inactiity. But i get this prompt to save. Am I minstanding how this feature work?
