-
Get values in card header display or get total items of a type without countif for each?
When viewing by a category in card view (think color), it places the number of items in that column in parenthesis next to the column title. All of the "blue" items are in the column and the column header is "Blue (22)", the next would be "Red (12)" and so on. Is it possible to get that number for use in a dashboard (and a…
-
Forumla HELP! Check boxes then counting £ values in columns
Hello community This is my first post, struggling to achieve a formula command. can you help? I have several columns, one being a check box column named "Payment" When one or more of the rows is checked within this "Payment" column, I then need the system to calculate the £value across three other columns, names "30 days"…
-
Bug, Missed Release, or Senior Moment (column reference)
I am pretty sure that if I had a formula like this: =SUM(A:A) where A is a column, if I copied that to another column, it would update (ie, was a relative reference) It doesn't. If I copy this formula: =SUM(A1:A6) one column to the right, I get =SUM(B1:B6) as expected. There are three options: 1. This is a (newish) bug 2.…
-
Formula Help with Symbols Column
Hey, can anyone help me with this? I have a column called Time to Comp which is a dropdown with the following - 5 10 15 30 45 1hr 2hr 4hr 8hr I have another column called TimeCompSym with the 1 - 5 stars. I would like this column to populate the stars based on the value in the Time to Comp column. 1 star = 5 2 stars = 10…
-
Using VLOOKUP to return a most recent date but with conditions
Hi there, I'm looking to pull off the following: * Smartsheet A is a list of stakeholders we regularly engage with. Every row is an individual stakeholder * Samrtsheet B is a tracker where we list the engagements themselves. Every row is an occasion where we have interacted with a stakeholder. We categorise these…
-
Having Issues with COUNTIFS function
I have a sheet in which I reference another. What I am trying to do is reference two columns from one sheet to count the amount of entries that match the logical expressions. Here is my current formula. =COUNTIFS({Copy of Incident Report Range 1}, "Burn", {Copy of Incident Report Range 5}, 1) What I want the column to do…
-
SUMIF referencing cells across sheets?
Since reports do not have the capability of summing the content of columns or rows I need to come up with a workaround. For several years I have been doing exactly this in Excel so I want to duplicate in Smartsheet. In Excel I have created a table that is a list of employees in the rows and a list of dates in the columns.…
-
Calculating Time Values
Hi Team, I am new to the community but have been a SS user since 2012. In some reagrds I am still a learner but in my process ability I am building amazing stuff. Let me just say it has transformed my world and clients I work with! I am getting to work with some real complicated setups and trying to translate that into a…
-
See Current Sheet References and Delete them
I have a sheet i'm building and I have run into the maximum number of sheet references. This isn't a big deal as I've just made another sheet, and i'm going to use a report to conglomerate them, but I found out that I cannot go through my references and delete some of them, or even see a list of the references made. Is…
-
Parts of a whole inventory suggestions
Hello! we use Smartsheet mostly for inventory management and I was wondering if anyone had some suggestions on how to write a formula to automatically subtract the parts that go into each item while also subtracting the completed part. I currently link in the part inventory from one sheet and update it there so that it…