-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
Be great if Smartsheets could be used offline
A number of regions (countries) have very tight internet use. It would be helpful to be able to download local version, work on it while abroad and resync on return.
-
Copying/Moving attachments to other rows
Good afternoon, I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements. In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the only way I see to do it is to download the attachment and then upload to the new row (it's…
-
Retaining Email Messages as comments
Is there a way to retain email messages as comments, when they are sent directly from a row in Smartsheet? If not, this would be a great addition.
-
Is there a way to create multiple columns on a web form?
I would like to create a web form, but do not want it all listed vertically. Is there a way to create a form in landscape with multiple columns?
-
Set default text for a given cell
I am creating a template and would like certain cells to give an example or show what type of information should be entered. The default text should be in that cell always unless other text is entered in. If the newly entered text is deleted, the default text would show up again. In doing some research, this type of field…
-
Can Smartsheet get data from custom HTML forms on a website?
Hello, If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit prettier. Thanks in advance!
-
A keyboard shortcut to delete the selected row(s)?
I can't find how to delete the selected row using keyboard. I can only do that using mouse. It's very inconvenient - in MS Project I select entire row using shift+space and press Delete to actually delete it. In Smartsheet when I do that - it just clears the row but keeps it there. It's very inconvenient to have to switch…
-
Any way to use a cell value as a row number in another cells formula?
Hi all Anyway to get the row # from a cell value and use it in a formula? Example this works: IF(COUNTIF([Assigned To]$974:[Assigned To]@row, [Assigned To]@row) > 1, "DUP”,1) Now let's say Column1 row 23 contains the value 974 I would like to do this: IF(COUNTIF([Assigned To][Column1]23:[Assigned To]@row, [Assigned…
-
Date Modified - Copy of column creates different date
Hello, I am working to create an automation off of the date modified field. This is to alert users if they have not updated a row in more than 4 days. Since the date modified field is not recognized as a date field I created a copy of the column using the basic formula: =[Last Modfied]1 My results are not what I would…
