-
Unified task list
Hi everyone! I started using Smartsheet to control all the projects in my company(aproximatelly 9 projects). Some of them have confidential parts, but they also need colaboration of other employees. Can I create a unified task list for each person so that they can view and update only the task related to them, withou…
-
Countif Formula
Hi everyone! Im having trouble with a simple COUNTIF formula. I am getting "UNPARSEABLE" but for the life of me, I just don't know what I'm doing wrong. I want to count how many times the "Weekly Goal" was met in a range of cells. screen shot attached.
-
Countif using Dates and another Range
I'm trying to use CountIf using the my auto filled date column and another column. The 2 parts of the formula I have come up with work independent of each other, but when I try to put them together I recieve the #INCORRECT ARGUMENT reply. Not sure what is wrong. Below is a copy of my Formula. =COUNTIF([Request Create…
-
Task Status Formula help
I am trying to update the below status formula to update the "yellow" status to be determined by a % complete less than 25% and the Due Date (week of) is between 7 and 14 days in the future. Here is the current formula: =IF([% Complete]26 = 1, "Green", IF(AND([% Complete]26 <= 0.25, [Due Date (week of)]26 > TODAY()),…
-
Timeline Display Dates Before Project Start
Im new to SS. Does anyone know how to change the setting on the gantt timeline display to start the day of the project. I've played around with the primary and secondary headings but the timeline still prints before the project start date. Example: My project started on 12/30/15 but the timeline starts on 12/1/15.
-
Dynamic Drop Down list
Hello! As you have already seen in forums, many customers demand drop down lists, that uses master column as the list entires. Whenever you add a new entry, the list in all other sheets updates with this new item. Do you have any other way to get this done, for example, external database linking or other solutions. We are…
-
Publish Calendar View
Is there way to publish the calendar view only? I am needing to share just a bit of data in a calendar view only without sharing the entire sheet. Thank you in advance for any help.
-
Dashboard Widgets PDF Issue
Hi Community, Need some help with exporting Dashboards to PDF. Seem that all the widgets export extremely low resolution. The text seems to be fine, but all widgets regardless of how large or small i make them export low resolution and pixelated. I need to send some dashboards at PDFs and not live URLs so this is a must…
-
Smartsheet Python SDK Pyinstaller
Has anyone had success packaging their python applications for smartsheet into executables with pyinstaller? I've tried adding hidden imports, updating spec file, and running a clean venv with python 3.4 yet I still get an error message the second the program gets to the object associated with smartsheet. It states that it…
-
Need Help - Can't Wrap my Head Around SS Logic
I'm trying to build a metrics table that can be used to generate a graph on a dashboard. I am a consultant and would like to track client hours from a master sheet that logs all clients, dates of services, and total hours. Let's say I wanted to track the hours of utilization from a particular client from YTD, Last Month,…