Government

 

Discussion List

  • COUNTIFS between dates & criteria.
    In Formulas and Functions
    Greetings Smartsheet Community,     I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame.    So far I am successful counting the dates in the range using the following formula: …
    4033 39
    4K views 39 comments Most recent by WendyR Formulas and Functions
  • ODBC Connection with Visio
    In Apps, Integrations, and Add Ons
    Hi All,  I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to c…
    262 4
    262 views 4 comments Most recent by C. Powell Apps, Integrations, and Add Ons
  • Changing the default Timeline Display for Gantt Charts?
    In Using Smartsheet
    Hi there, Is it possible to change the default Timeline Display options for Gantt Charts (whether in Sheets or Reports, or ideally differently for each) such that when a new user views them for the first time they see the settings that the…
    Answered - Pending Review
    32 1
    Answered - Pending Review 32 views 1 comment Most recent by Julio S. Using Smartsheet
  • Hide comments in a published report?
    In Using Smartsheet
    Hi there, Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as "Read only - HTML", but this option does not appear to be available when publishing a report. There are comments …
    Answered - Pending Review
    770 6
    Answered - Pending Review 770 views 6 comments Most recent by kerobi Using Smartsheet
  • What's with the "unnamed series" in the pie chart?
    In Using Smartsheet
    So I've created a pie chart in my Dashboard and let's say I have basic data such as: Apples 5 Oranges 12 Bananas 8 Blueberries 20 Strawberries 3 Rasberries 19 With this data, when I tried to import it as shown above, it gave me an e…
    1042 6
    1K views 6 comments Most recent by Genevieve P. Using Smartsheet
  • Centering Gantt chart bars vertical alignment?
    In Using Smartsheet
    Is it possible to "center" the "vertical" alignment of the bars on a Gantt chart (in a Report, but also in a Sheet)? The default seems to be that they appear at the top of their row, but I'd like them to appear in the …
    Accepted
    22 1
    Answered ✓ 22 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Automation Trigger "When Rows are Changed" not working
    In Using Smartsheet
    I have been banging my head on this. I need to set up a very simple trigger that when a cell is updated, a notification is sent about that row. I am using the "When Rows are Changed" trigger and defining my cell condition, and fi…
    2246 15
    2.2K views 15 comments Most recent by Lori Martin Using Smartsheet
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1594 5
    1.6K views 5 comments Most recent by L_123 Formulas and Functions
  • Using IF and CONTAINS in one formula
    In Formulas and Functions
    I am trying to create a formula that returns: Tolerable if the answer is Low Tolerable if the answer is Medium Acceptable if the answer is High Acceptible if the answer contains Urgent. I need to figure out how to use "CONTAINS"…
    Accepted
    25 1
    Answered ✓ 25 views 1 comment Most recent by USB Mike Formulas and Functions
  • Dashboard access via link not showing the user as logged in.
    In Using Smartsheet
    So, I am having an issue with my published dashboard. I have embedded a report utilizing the current user function. I have found that when my team accesses the dashboard by manually navigating to it through SmartSheet, the report works per…
    169 3
    169 views 3 comments Most recent by Genevieve P. Using Smartsheet