-
cost and efficiency trend calculator
I just started using smartsheets for out development firm. we have hundreds of new consturction homes that we keep seperate data sheets on everything from bidding, to actual cost, to scheduling. I would like to be able to pull the data out of each sheet and generate a report that details how much I pay for each style of…
-
moving rows in reports (without using Sort)
Is it possible to move rows around in a report without using the Sort function? I have a report that pulls from 3 sheets, and I want to change the order of the rows from each sheet (not individual rows if that helps). Sorting only changes the order numerically or alphabetically, which I don't want to do. Any ideas?
-
Emailing a report
Hello.. I have a report set up to run every Monday to show uses a list of their "issues". Is there a way to skip the email if the report is blank? Now it sends a blank attachment Any ideas? Please let me know Thanks!
-
Smarsheet as a payslip app.
Is it possible? I need to automate my timesheet into a payslip afterwards. Tell me how can I do that? Thanks.
-
One tab, multiple reports?
Smart Sheet has proven to be an amazing tool. In using it, I have built several reports that are starting to take up too much space on my display. Some of these reports are very similar (Quarterly reports, for example, are taking up four tabs per year) and I want to consolidate them into one tab. How do I create multiple…
-
Consolidating names in a Columns
We use Smartsheet to manage several projects, with multiple and repeat customers. We need to create a report that reviews (2) columns (distributor and customer) from serveral sheets. We would like the end report to combine the (2) columns from all of the sheets and remove any duplicate names from each column. I have gotten…
-
Live Data Connector
We're considering upgrading to the Enterprise license so that we can use the Live Data Connector, but before we do, wanted to confirm if you can build reports against "Resource Views" data? From what I've read, can certainly author reports against smartsheets, and I suppose I could reconstitute the data that appears in the…
-
Updating projects when parent & child rows are involved
Hi, I have built a large projects register for my organisation which uses parent rows to express the Project Name, and children rows for each Stage of that project. So for example Row 1 would be "Park Upgrade". Row 2 would be "Initiation/Planning". Row 3 would be "Design/Development" etc. Also on the each children row, I…
-
Trying to get a formula to work
I am currently trying to get a formula to work in Smartsheet that will count the requests we have outstanding that havent been completed and are over 41 days old. But that will also take into account when new lines are added to the document. The formula I have got working in excel is: =COUNTIFS(B:B,"<"&TODAY()-39,C:C,"")…
-
Combined Reports
I have a combined report that is pulling information from 10 different smartsheets. The columnar information is the same from each of the smartsheets. I have it grouping by the smartsheet the information is coming from, but I would like the "title" of the smartsheet to show up at the beginning of the data from each sheet.…
