-
Pop ups
I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not have this issue on any…
-
Adding together multiple COUNTIFS?
Hey everyone. I'm trying to implement a formula that will allow me to reference two ranges from one sheet and follow the specified criteria that is given to them. My most recent attempt; =COUNTIFS({Unit_Type}, "CP2 - Double", {ACCS Overall}, [T2]26) + COUNTIFS({Unit_Type}, "CP4 - Double", {ACCS Overall}, [T2]26) +…
-
I deleted my Predecessors column and now have no access to deleting any Predecessors relationships.
The docs say I can do this in the Gantt window, but I've found no specific instructions on how to do that, and haven't been able to intuit this process. Another solution would be to restore my Predecessors column. Inconveniently, copying and pasting columns between separate sheets "is not supported at this time." I imaging…
-
Formula to automatically check a box when a certain cell is populated
I am trying to get a column to automatically check a box when certain cells are populated in the same row. This is linked to an update request situation. Basically, when an update request is fulfilled, OR when a certain cell has information in it due to the update request being filled, I would like a certain box to be…
-
At-Risk Flag
Good Day All, I am wondering if there is a way to apply this format to my sheet. I want to be able to move a task to the executive dashboard automatically/ real time. For example, I want to be able to mark a task as at-risk and the task will move to the project dashboard automatically. I am still completely new at…
-
OR function to check a box
I am trying to get one box to check under one or another conditions. 1. when a certain cell has any text 2. When another certain box is checked The function I came up with follows, but it doesn't seem to work. There might be one small tweak I need to make, but I am still new to making formulas. Thanks for your help!…
-
Battle over Sorting and Filters
Greetings, We are starting to use Smartsheet heavily in a lot of our processes. We deal with contractors on a daily basis. We have several groups of contractors that view one master sheet and each of their own set of columns they review and work with. They may not directly interact with other parts of the master sheet, but…
-
Project Plan with several Tasks in one Line
Hallo! Currently, we have an Excel sheet, which I would like to transfer in Smartsheet. However I cannot find a way to do so, so hopefully someone can help me. As seen in the picture, every row is an own project and every column (except the first with the name of the project) is a certain day, like a Gantt. So on every…
-
Smartsheet Referral Program
Hi, Wanted to check if smartsheet has any referral program (where existing user introduces new users) ? If yes, how does the same work ? Have tried checking the app but unfortunately couldnt find any such information pertaining to referrals there. However there is a Smartsheet Referral Agreement available on web thus not…
-
automatically export and then delete rows
We use SmartSheets to collect a large amount of data using a form. We reach the Smartsheet size limits almost weekly. Currently we log in each week, export the data to excel, and then delete rows based on a date criterion. I have looked at Zapier. It looks like I can have it email me the data in excel but the free version…
