-
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. I've never used the TIME function before, but I'm hoping I can use this to try and save having to add multiple helper…
-
Use Javascript in Bridge to efficiently import data from an API
Hi all - I'm excited to share a custom Javascript solution with my fellow Bridge users. I am not a Jscript coder - all credit for this goes to the awesome @Nathan Lloyd at Smartsheet - Large Enterprise Technical Sales Engineer, who gave me the basis for this script at ENGAGE 2022. Thank you Nathan! In this thread I'll…
-
How to populate duplicate numbers into sheet?
Hello, I have one main sheet that tracks all incoming DRR #'s and every row has a couple of names in it. I want to build another sheet that tracks names based on the DRR # but want it to populate in different rows, like below. So two people are on 0001 while in the main sheet that would only be one row
-
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…
-
how to transfer sheet ownership from a user that is no longer available?
I have a number of sheets whom current owner are no longer in the organization and the email associated no longer active. How can I retrieve the ownership of said sheets. Thanks
-
Automatically Sort Rows in Sheets
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
-
Merged: certain cells remain locked until specific data is entered in another cell
This discussion has been merged.
-
Lock single cell
It would be very useful to lock a single cell. I see it's been asked many times on the community but I did not find anyone submitted it as an idea
-
Rich Text formatting in cells
I would love to see rich text formatting be available in cells on a sheet. We have several reports where we rely on certain words in a cell to be a different color than the other words in a cell (quickly showing variable options or redlining changed content if only a word or two has been altered). Currently, we are only…