-
Custom Jira fields not in Jira Connector
Hi - I have a new Jira custom field I want to pass over to the smart sheet, but when i come to configure the connector between jira and smartsheet, the field is not available. Other jira custom fields are. What could the issue be?
-
formula to distinguish decimal versus percentage (i.e. 1 versus 100%)
I have a report that combines many sheets. Sometimes the values entered as 1 rather than 100% (or .75 rather than 75%). The report is an input into Tempus (Smartsheet partner) and it makes a difference to their application. Is there a way to determine that a value is NOT a percentage? Or require entry of a percentage, or…
-
Creating a Cash Flow Model
Dear Developer I would like to know if someone would be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers…
-
Project Management
Hi, we currently have a few web forms, that allow clients to request quotes. These then populate fields on a smartsheet as normal. We have two challenges that I'd like to implement but can't seem to get it right. We would like to give the client more visibility on the status of the opportunities, but for various reasons,…
-
Uploading large excel sheet
Yes, I read the blog posts from 2016/2017. I tried loading a sheet with 32 columns and received an error message indicating I had over 200 columns. In my opinion, the error message is misleading. Submitted this to SmartSheet support. Just wondering if anyone else is having an issue of this nature.
-
Scheduled Backup
I am trying to set up a backup on our main sheet (This one has info from other sheets linking into it) I am able to select schedule recurring backup for my entire workspace, but we don't need all of that. All we need is one sheet to be backed up each week. When I right click on the sheet it will allow me to request a…
-
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
CheckList items not present from Trello import
I imported a board from Trello, where I used CheckList on a lot of cards. It now looks as though the items on the CheckLists didn't follow the import, just the number of items and how many are completed. Can I find those items anywhere or are they not here?
-
Taking three customized smartsheets and putting them into a new Project sheet
We have three smartsheets that are all unique, but need to combine them into one Project sheet. They're medium size, so copying and pasting might work, but wouldn't that require all formats to be the same? That would take a fair amount of effort to do. I suppose I could export them all and then manually set them up in the…
