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…
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 formul…
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…
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…
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…
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 a…
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 o…
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 numbe…
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 …
Has anyone had a problem with vlookup not updating? I had a situation this morning where vlookup was not refreshing the correct value when the search value changed. The way I found to fix it was to re…
