-
Sheet ownership
I implemented SS here at the bank over 1 1/2 years ago with little to no knowledge as to how the permissions worked. As the owner, I started making sheets for department managers and even doled out a few licenses for people who had specific needs. We are now experiencing growing pains with SS. We have hundreds of sheets…
-
Help
I inserted a row at the bottom of Product Development and the End Date did not change at the top level of the cycle. My cycle ends on 12/27/17 and the End Date shows 11/27/17. I tried to edit formula but cannot. Example file attached
-
If cell fill is a given hex color code, then return value
How can I identify the hex color code for the cell fill options? I want to write an IF statement to return value of 1 if the hex color code is the darkest blue (as an example). A little background.... reporting 6 status stages so the symbols aren't an option. Thanks in advance for your help!
-
New sheet based on filter?
I created a filter which only shows the launch dates. I'm trying to export these dates to iCal but whenever I do the filter is not applied within iCal and it includes every subtask. I figure a work around would be to make a new sheet with only the filtered launch dates and export that to iCal, however I can't figure out…
-
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?…
-
sort rows by revision date
Can a sheet's rows be sorted according to date of revision? Sorting this way would allow a quick view of the latest revisions that have been made to the sheet.
-
Cheery picking data from a sales sheet for customer to view
Hello, We maintain orders for customers in a sales sheet, the columns look something like this; Order Number Customer name Description Manufacturer Order Status Ship Date Delivery Date Sales Value This is our master sheet. So to update our customers we have to look at the sheet and email them important information from it.…
