Formulas
Discussion List
- 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…
- We use a unique number sequence by combining two integers for each row sent to Smartsheet. I worked with Zapier to verify that the integers are sent to Smartsheet as a string, not a number. What I am …
- Hi folks. I'll do my best in describing my issue. Trying to create a formula that multiples 2 columns together however getting #INVALID OPERATION error. Does it have to do with a column that is actual…
- Hi, Is there a way to sort a sheet where the formulas do not change. I have a few formulas at the top of a sheet and whenever someone sorts through the sheet, my formulas change based on where it was …
