-
Data privacy in community app
I'm new to the fantastic community and have a question re data privacy. When registering with my Smartheet details I was required to allow the Smartsheet Community App to "Read Sheets, including attachments and comments". I presume that this simply means that the app is allowed to verify my account, rather than that my…
-
Selective Count
I’m trying to get a count based on 3 different conditions. The formula that I have so is =countifs($[it track]$2:$status$500, “01. Reporting”, $[it track]$2:$status$500, “ Tier 1”, $[it track]$2:$status$500, “Green”) If all 3 conditions are met than a count is added. But its not working what am i missing? Thanks
-
switching accounts
I have been with my company for 9 months now, and prior to my employment that have not heard of smartsheet. I purchased Smartsheet before I was employed here and intrduced it to the company. Since then the company has seen how useful it is and wants to purchase and pay for it. How can I get the account switched over to the…
-
Fiscal year set to Feb causes year to be incorrect
My Timeline Display is set to fiscal quarters then months. e.g. Q4 FY 2018 / Dec 2018 If I set the fiscal year to start in Jan everything looks fine. If I change the fiscal year to start in Feb the calendar shows the current month as Jan 2018 and the next month to be Feb 2019 instead of Feb 2018.
-
Automating check box for multiple values
Hi, I need help writing the formula to automatically check the box when any one of these three values is selected: Complete, Cancelled, or Passed_Conditionally. Thanks!
-
Forms using drop downs
I read in an older post the when using forms you can only use values within the drop down even when "restrict to dropdown values only" is not selected. Has this been resolved yet by Smartsheet?
-
Axis scaling for Charts by Smartsheet
I have a standard line graph that my data now exceeds the vertical axis; however, I find no place to adjust the scaling. I the axis from lest to right and it scales, but, now not including 0. It now starts the axis a few values below the lowest value. I switch back to left axis and the chart now starts at 0 again, but, my…
-
completed tasks
Hello. I have set up a basic sheet to track open tasks with due dates. My question is once the tasks are complete, is there a folder or someplace where I can archive the completed tasks instead of them showing on the same sheet as the open tasks? Also, are separate tabs available that may be related to the open tasks…
-
Auto Locking a Dropdown in a Form
We are trying to create a form or update request (not sure which would be best) that allows external users to select a date and time from a dropdown list and when one person has selected that time it then doesn't allow another person to select that time and disables it as an option. Is this possible with some sort of auto…
-
Auto Update Request with a Single Attachment
Here's the scenario... * I have an auto update request set up that is sent to customers based on key dates related to their project row * I attach multiple files to each customer's project row related to their project. Some of which they don't need to see. * When the auto-update gets sent out, there is a single PDF…