-
Jira Connector Sync - Rows getting rearranged
Everytime I update my plan on smartsheet that uses Jira connector, post the sync with Jira, it re-arranges the rows in a random order (maybe based on order of sync). Why does this happen and how can I lock the rows so that the hierarchy I define on Smartsheet manually never gets re-arranged but only receives updated value…
-
Creating a Cash Flow Model
Dear Developer I would like to know if any one 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 etc. I…
-
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…
-
Update Row background with API
Does anyone have any C# code to just find a row and update the row background color (highlight the row). I have it on another program, but because my rows have System Cells (Created By & Created Date) I have to completely rebuild the rows with the cells before I can apply the format. I was wondering if there was a quick…
-
Looking to Hire Smartsheet Help
Hi all, I see so many great features with Smartsheet, but have been struggling with having the time to learn the program in order to properly use it. Wondering if anyone with excellent knowledge of the program can offer their services to help me set up some project management and product management templates that I can use…
-
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,…
-
Zap error 403 and 400 withe row update trigger - send row
Hi I getting trouble with my Zap. And so fare i cant figure out the problem. Is there a way you can help me to get this working again ? The Smartsheet have been the same all the time, but the problem suddenly startet urly last week. I reach put to yesterday av got this tip: Thanks for reaching out! Looks like your Filter…
-
Auto attach emails to Comments on my Smartsheet
Something that would be very helpful is to have a way to automatically attach an email received in Gmail or Outlook to a Smartsheet row by inserting the email into the comments column. The email could reference the sheet and specific row by searching for an existing primary key or some other field on the sheet. Yes, but…
-
Smartsheet Merge & Google Sheets
Does Smartsheet Merge App work with Google Sheets? I have been using the Smartsheet Merge App with the Google Docs, however, when trying to use it with a Google Sheet, it doesn't appear on the list. It seems a shame not to be able to when Google Docs does..
