-
Ruler - alignment tool
We are only 6 months into our Smartsheet journey and thus often tinkering and creating new reports, it would be really handy to have a ruler at the top in order to align fields/columns in reports. I have marked where a ruler could sit with highlighter yellow below. Does anyone else recognise the need or have an alternative…
-
Sumif for an month to day invoice amount with date criteria
I have an Invoice Smartsheet which has invoice amount for invoices for last several months. I have to calculate month to day invoice amount. I have given the following formula: SUMIF([Inv Amt Rs]:[Inv Amt Rs], [Inv Date]:[Inv Date] > "02/01/2018") This evaluates to zero, even though invoice amount is there in the range.…
-
offrs here - new to the community and doing a review for Real Estate use
New to the community here. Interested to see how Real Estate agents are using smartsheet for their business. Looking forward to hearing about it. Thanks!
-
Pie Charts in Sights
Hi, Thank you so much for adding Charts to Sights! It appears as though the pie charts can only handle three data points, is this correct? Or am I possibly doing something wrong? Thank you!
-
Calendar - equipment booking
hi i am wanting to set up a calendar for keeping track of the equipment we hire out. i want the months /weeks/days across the top and equipment down the side. i can seem to get it to work correctly. any help would be much appreciated.
-
Key Account Management
I am looking to create a Smartsheet that will help me track my customers over the year. I work for a company that sells, deploys, and maintains ERP systems. That is Enterprise Resource Planning. I look after the customers after they have 'Gone Live' with the system. After they have settled down my objective is to run with…
-
sumif with children and checkboxes
I'm trying to create a setup where I sum together only the children if another box for that row is checked. I've come up with (see screenshot below as well): =SUMIF(CHILDREN(Include),1,CHILDREN()) But despite trying different variations of the formula I get everything back as #UNPARSEABLE I appreciate any help you can…
-
Multiple vendors and corresponding part numbers
We are using Smartsheet to manage inventory. We purchase the same materials from multiple vendors, depending on pricing and availability. Is there a way to list the multiple vendors with their corresponding part numbers without indenting lines for each vendor below each and every item? The time required for that solution…
-
Formula for SUM by the category
Unfortunately couldn't find the solution here. I'm just looking for a formula that will allow me to count total sum by the category of a product. Basically, I have two columns: first is the Dropdown list with the category of a product, and second one is the Text/number column with the bid amount. What I need is a total sum…
-
Formulas and Reports
Hello everyone This may be a simple fix; however, I am fairly new to Smartsheet and any insight would be appreciated. I built a report that is linked to three different sheets. They were originally imported from Excel that way the formulas would carry over easily. When I pulled everything together, the three rows that I…
