-
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…
-
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…
-
Report filter not working properly
Hi, I'm not sure if there is an inherent filter mechanism as part of Smart Sheet reports but I am trying to use the report filter function to only show rows for specific information. Column 1 - list of products (e.g. apple, orange, grapes .. etc) Column 2 - list of groups that buys the product (e.g. group 1, group 2, group…
-
time analysis via modified columns for automated alerts
I'm trying to find a pattern as to how the numbers are generated when two modified by cells are subtracted from each other. At first I thought it was in minutes and separated via location in the number, but upon testing that proved to be incorrect. Does anyone know how to translate the number that is given when two…
-
Dates Less than 1 duration
Trying to get a formula to calculate less than day if duration is less than 1 whole day. Example - Start date is 7/30/2018 End date is 7/30/2018 Duration is .12d Formula Variable Date is 8/14/2018 If I want to run a formula to calculate the days from Variable date less end date - I get 15. I am looking for something more…