-
Calendar Day Settings
Is it possible to make individual lines 'Calendar Days' rather than working days? - I have investigated into the project settings and it appears that the calendar dates can only be amended if it changes the whole project? Any advice would be much appreciated.
-
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…
-
=SUMIF Help please:
Hi Team, Formula not working…(#UNPARSEABLE) =SUMIFS[Value of Job],2 [Sold Date:]2,>DATE(2016, 12, 31),[Sold Date:]2,<DATE(2017, 2, 1), [Result]2, 1 Trying to get “Current Month Sales” to calculate “Sold Date” when “Sold Date” matches the current month we are in (January) * * When February rolls over I wanted “Current Month…
-
Blocking Exporting
Hi, Is there currently an option or setting to block a viewer from being able to export data? I cannot seem to find it. Thanks!
-
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…
-
Fixed Cell Reference
I have search the db for answers but likely have my terminology mixed. I have a sheet which is populated by clients via a web form. New entries appear on the 1st line. I want the value in 'Bears 1' to populate in another sheet or on the same, doesnt matter. The specific cell is key as this is the most current value.…
-
Informal user survey: task completion check boxes
Hi, I keep running into systems that have a variety of names for check box columns that are intended to mark task completion. If you wouldn't mind, please follow this link: https://app.smartsheet.com/b/form?EQBCT=5b8cc9b3e70c42b2b20c795cf2a37877 to tell me the column name you use (or if you don't use one). I appreciate…
-
Unwanted Scroll Bar in Sight
I recently built a sight (2 screen shots included below) and I'm wondering if anyone has come across this issue and if they know of a way to fix it. I have a report widget and for some reason I can't get rid of the scroll bar on the bottom. I would like it to be wide enough that it doesn't need a scroll bar, but, as seen…
-
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…
-
Calendar Days inactive - please help
We use Smartsheet calendar to schedule in our sales - however the month of january is greyed out and inactive? Cannot add any events in - only way is going back to previous months, adding, then changing the date to january ? Any ideas how to resolve this issue?