-
Hyperlinks to other sheets not working from report
I have a sheet where one of the columns has a link for each row (project) to a detailed project sheet. When I run a report and include the column with the links in the report, the links are not clickable from the report, so users can't get to the other sheets. Is this as designed or is there something wrong with the…
-
IF/AND Statement to yield check box answer
Hi Smartsheet wizards. I am trying to create a formula for the following logic to track my teams contact with clients. Essentially if a team member hasnt contacted a client within 30 days, to produce a check mark. We have a small team so I planning on copying this formula to a seperate column per team member and then…
-
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,…
-
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?
-
Sharing and Limiting Report Information
Scenerio - I have a MASTER sheet that I am using to communicate with different contractors via individualized reports. The contractors are required to make updates to several fields. Once I assign a line or job to a contractor - it shows up on their individual report. Each line/job has contract specific details in the form…
-
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…
-
Conditional formatting across multiple sheets
Is it possible to set conditional formatting to move an item from one sheet to another once it is completed?
