-
Previous and Next month buttons not appearing in IE
We are asking team members to enter future delivery dates using a Date column. Unfortunately, the previous and next month arrows are not appearing in Internet Explorer. Nobody had complained about this issue until today. Is this a known issue? Other than switching browsers, is there a solution?
-
Change Request - Remove ability to edit filters.....
For users of <user - can't share> level permission, turn off their ability to modify / duplicate filters on sheets that have been shared to them. The filters I give them with a sheet are the filters I want them to use, no other! The minute they see that they can duplicate / change filters our workflow is hosed. You are on…
-
Timesaving Features - Please!
1. When in Admin mode, ability to actually lock rows and columns on the sheet you are working on. Lackcing this, we throw away one seat on the three user system as we use Admin exclusively for programming, building filters and administrating the Workspaces. 2. Double click on format painter holdls the sample in memory…
-
Totals by Month using a date column
Is there a formula to count the # of entries for each month, using a system created date column? It seems like this doesn't exist unless you create a new column that says either 12 or December by looking at the date column.. thanks!
-
Return 1st Day of Month for a Date
I am trying to avoid complex formulas however have not found a better work around. Objective: Column/Cell includes a Date, I would like a second column cell to return the Month for that cell Example: Column: Invoice | Column: SchedMos May 15, 2016 | May 1, 2016 =Mos(Invoice1) June 22, 2017 | June 1, 2017 I am familiar with…
-
Populated Report for me but blank for Recipient
I'm wondering if anyone else has had this issue before.... I created a report from one sheet that has approximately 14 lines on it; the person I shared the report with shows it to be blank. The Report Builder, on their end, shows the 'Where?" as <unknown sheet>; the "Who?, What? and When?" are the same as what was built.…
-
Issues with Smarthooks verification.
I am not sure if I understand smarthooks correctly or if smartsheet just made a "dumb" implementation. I can create a hook but verification failosm OF COURSE. It expected the url to send something special back (Smartsheet-Hook-Response: <sendID>). Unless this is not a generall webhook standard that bodes get echoes back,…
-
Filtering Calendar View
Is there a way to filter the calendar view to show more information (from other columns) rather than just the primary column information?
-
Setting RYGG Based on 2 Columns
I'm trying to set up RYGG based on a Finish Date column and a Status column. Here is what I have so far: =IF(Finish6 < TODAY(), "Red", IF(Finish6 = TODAY(), "Yellow", IF(Finish6 > TODAY(), "Gray"))) What I would like to accomplish past this: Yellow if 5 days prior to Finish Geen if 6 or more days prior to finish Gray if…
-
Nested ISBLANK Formula issue
Hi all, I've having some issues with the formula below and was wondering if anyone more knowledgable than I could take a look for me. I don't get an error message I just get a blank cell which is actually worse than an error message. =IF(ISBLANK([WPA2]47), [WPA1]47 + [>30PEE]47, IF(ISBLANK([WPA1]47), RCM47 + [>30PCM]47,…