-
Charts From Drop down Data
I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option?
-
FORMULA - Pulling Data from last row filled
H E L P P L E A S E I have 5 rows (children) of possible data input areas. All 5 rows may not always be used. In Column "M" a number of 1,2 or 3 will be entered. Based on this number, Column "A" of the parent row should reflect "Closed" if the last row containing data is 1 "Work in Progress" if the last row containing data…
-
Hidden and Locked columns are visible for Collaborators under search and edit..
Hi, As an admin we made some columns as hidden, but collaborators are able to see under search and edit the row options. Suggest me how to avoid it. Thank you.
-
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…