-
Unable to access specific sheets
Hello, Has anyone lost access to a sheet due to a generic Ajax error and had it successfully fixed? We have a Enterprise account with hundreds of users, yet none of us are receiving timely communication or any resolution plan from Smartsheet support. Have any of you run into this before? I am very concerned we are going to…
-
Locate/Find COUNTIFS
e.g. =COUNTIFS(Recruiter:Recruiter, "Christie", [Deal Date]:[Deal Date], MONTH(@cell) = 10) e.g. = 50 This is an example of how I identify my "deals" for the month in a sheet which lists every deal my company has made. The sheet contains thousands of lines. Is there a way to search/locate/find or highlight these 50 deals?…
-
Notifications and other communication not working
Dear Smartsheet, I had a short presentation of Smasrtsheet functionality and I have faced huge problem with notifications. I have a couple of sheets where all notifications are not sent for some reason. I am trying to play with fields that are triggering these notifications and none of them are working. I have checked if I…
-
Cell Linking for Updates?
I'm trying to find a solution to reduce the number of updates my team and I have to do. We currently use Smartsheet to create and manage project plans but also have a master "Status Sheet" that lists all projects, their current task, and the deadline of this task. Whenever we update the project plan, we also have to update…
-
new feature on engage conference:approval request
Hi, I have difficulty to understand new feautre of approval request. I am a property management company and every month need to upload financial report to client web site. Accountant create financial report, then account manager need to approve, after account manager approve, client approval, them mail room will mail…
-
Smasrtsheet freezes and crashes Chrome
Today I created new sheet and it started to freeze when I click anywhere on this particular sheet, which is almost empty. Other ones seems to be ok, but this one I can't use at all. Anyone faced similar issue? I have restarted my PC, etc, but still nothing. Yet, I had to present this sheet today to my boss, so you can…
-
Formula: Look Up for two value
Hi, This one is pretty easy in Excel but I have no idea how to do that in SmartSheet. I have 3 columns in SS: Fruit, Brand and Price [Fruit]1 is Apple , [Brand]1 is ABC Ltd. [Price]1 is 100 [Fruit]2 is Apple , [Brand]1 is XYZ Ltd. [Price]1 is 50 [Fruit]3 is Pear, [Brand]1 is ABC Ltd. [Price]1 is 100 I want to have formula…
-
'Conditional'/Multiple Predecessors
Is it possible for start date of a task to be based on dates tied to one of two other tasks? E.g. Task 2 must start not more that 10 days from completion of Task 1. Under normal circumstances, this allows task 2 to start not more than 10 days from start date of task 3. If start date of task 3 must be accelerated, however,…
