Hi Everyone! I need some assistance with a formula to extract single value from a multi-select drop-down to individual columns. I got most of the process to work but for whatever reason the formula fo…
Hello, I am trying to build an executive summary dashboard and would like to capture cell values at the beginning of every month to compile on a monthly basis. I have thought about using a row copy au…
Good evening, I am working on transitioning data from Excel to Smartsheets and am having trouble figuring out the Smartsheet equivalent to a formula I have used for years in Excel to spread contract v…
I manage a smartsheet that has a 2yr rolling forecast for 1,000+ expenses. At the end of the month, I would like to review and share all the changes that have been made to the "Cost" column. With work…
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…
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/Chan…
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 f…
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 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", "")
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 co…