Creating price tickets
Would be grateful for any guidance please. I'm looking for a way of producing sheets of price labels including a barcode that would be generated from a smartsheet. I can get all the relevant data into one smartsheet however I have been struggling to come up with a way of creating a PDF that would contain the price label…
Basic A/P and A/R payment tracker
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…
Can a range be specified with a beginning and no end?
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…
Microsoft Dynamics D365 Finance and Operations
There is only a connector for Microsoft Dynamics D365 but our company uses the Finance and Operations Dashboard for Microsoft D365. It will only pull information from CRM and there's no connector for the Finance and Operations information that we track. We have to manually enter that data currently because the connector…
I am trying to create a formula - If I Select "Yes" then multiply 25 by a specific cell.
The formula works, but it is not solving the equation and is giving me the words of the equation instead =IF([Per Diem Eligible (Yes/No)]@row = "Yes", "25*[# Nights]3", "")
Cross Sheet Formula Limit Error
I'm currently getting an error related to the cross-sheet formula limit. I'm not sure why I'm getting the error. So far I have referenced 6 columns in other sheets with SUMIFS formula. I received the error when I added the 2019 formula below. There are ~17,000 records on the referenced sheet, would that be causing the…
I have paid upgrading plan from Pro to Business, but the account still in Pro Plan, how to solve it?
Hi everyone, I need help, I have paid upgrading plan from Pro to Business, and i also received the payment invoice on my email that said that i have paid for business plan (screenshot below). But, my account still in Pro Plan (screenshot below), then i still cant use grouping at the report, etc. is there a wrong way? Does…
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
Dependant dropdown lists
Hi. Is it possible to create a dorpdown list that is dependent on the option selected in other column. For example, when I have list of 300 Banks with SWIFT codes . One column is Bank name, another column is SWIFT code. I also have a list of vendors and need to choose in vendor form their bank account. I write vendor name…
Attachment in an online Form
Hello, I have creeated an online form but I need that people can add an attachment (image). Anyone knows if this is possible and how? I guess it is possible as this form I am filling in has this feature. Thanks you for your help Ugo Quaglino