-
Automated Dashboard Metric Updates
Hello! I have a dashboard for one of my projects where I use a metric widget to share updates on each objective. I have an underlying sheet that sends out update requests every two weeks to the leaders of each objective. I have an automation within the sheet that archives old updates to an Archive sheet. I want the latest…
-
sorting date by Date column not working properly
Hello. I am sorting by date, on a Date column with info entered only in date format, by 'locking to date only". I choose descending and I should get (based on the kind of data I have in the Database) 2020, 2019, 2018, 2017, in proper sequence, but what I get seems to be random. I need this to work so I could generate a…
-
Automated Copy / Move rows between sheets - just copy some columns
Dear all, I'm a project manager and recently started using Smartsheet. I'm trying to configure an intake-prioritization and approval process for all the projects requested by our users. I have my main sheet called it : Project Requested 2021 then I created another sheet for the projects approved by the Board: Project…
-
Gantt view - exclude parent rows?
Can parent rows be excluded when using the Gantt view? I'd like the option of viewing the Gantt chart with just the sub-tasks and not the overall parent bar.
-
Is smartsheets payment system working?
I've tried repeatedly to add a new user to our account. Over the past three days I've attempted this a perhaps a dozen times by clicking through from the automatic email my colleague has sent via smartsheets requesting a new user licence. I have no success with it either this way or going directly through the 'change your…
-
Convert form response in to standalone project?
Hi, I created a Smartsheet form to intake requests for support from my team. I'm not aware of an easy way to then create a project based off of the form response without having the Control Center add-on. Ideally I would like to set up a system where I can view the incoming requests then approve/reject/send back for more…
-
Can Forms time out?
Hello, all! If someone is filling out a Form, is there a point at which it can "time out," so to speak? If someone is working on a Form that might take 15-20 minutes to complete (looking up information to fill it out, etc.), at any point would it reset? I imagine this is not a problem given the nature of Forms, but I just…
-
Exported File Hangs Excel
I am working on a complex set of sheets and I need to compare the data in two different versions. I have exported each of the two sheets multiple times and, as of this morning, any Excel version of an export hangs Excel when I try to open it. I realize this may be an Excel-only issue, but Excel is otherwise working without…
-
Feature request: Hashtags to create automatic reports
Hello! So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department. We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according…
-
Decimal Places in a cell
We have a Smartsheet that we use for tracking payments made to a different country and therefore in a different currency. We have an exchange rate column and for the company we use to make the payment, the exchange rate is given with 6 decimal places. However, the Smartsheet only allows 5 decimal places to show. Is there a…
