Hi Team! I am looking for any templates / examples the community has on building reporting and dash boarding specific to project financials. This includes, project spend, Capex, Opex, variance to budg…
I inherited a sheet that I'm trying to redesign. We have multiple purchase orders (PO) with multiple invoices applied to each PO. Once an individual invoice is paid by accounting, we want to mark the …
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and two of the columns have a rather complicated formula, which has a function I don't believe is available …
Hello, I'm trying to recreate/transfer a salary/reward solution in Excel over to Smartsheet and I've been able to recreate a good portion of the columns that have complex formulas, but there seems to …
Hello, dear support team, I have a question about combining several Index Collect functions. The Goal is: I want to get the Payment Terms into the Cash Out section of the Cashflow. As you can see in t…
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for …
Allow entry of custom job categories. Add new fields to capture a user's business unit and department. These fields should also be included in all user reports. This functionality would be helpful for…
Hello! I need help trying to figure out formulas that triggers the review status to green or red based on how many checkboxes that represent each month of the year are checked off. The boxes that are …
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…