-
Hide login button
I am dealing with people outside my company. I am sending them information in response to their web form submission that I have setup in Smartsheet. I would really like to use the discussion option but that invites them into my sheet, which I don't want. I just want to capture their replies. So I tried using send row but…
-
Drop Down Menus
Hello, I have a drop-down menu with a few selections and I want the next cell over to have a text based on what is selected from the drop-down menu. Can this be done? So on cell B3 I selected 5, and I want the word Tom to populate on cell B4 based on that selection. Thank you!
-
Outlook App Enhancement Request
I did submit this request through the Enhancements form. I love the Outlook app. What a time saver it is! I use the SS app religiously to save emails to my sheets. Sometimes I will save one with multiple attachments, images, only to receive an update from a co-worker and wil resave the new email. This means that the…
-
What data is sent to Zapier on the updated row trigger?
Hi, I want to send a custom email with data of a row when some of its cells are updated. The recipient of the email is in a column of the row. I try to do it with Zapier using the "Updated row" trigger but it seems that the data sent to Zapier is all the sheet and not only the row. Has anyone faced this? How could I only…
-
Check Box and Conditional Formatting
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…
-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
Appsheet timestamp date format
What is the trick to converting the app sheet timestamp date format to be recognised by smart sheet? On the face of it both look to be the same. timestamp format from within smartsheet is = 3/3/2018 11:48:41 timestamp format inputted from appsheet = 3/3/2018 11:48:41 I tried the DATEONLY() function on the app sheet date…
-
Date Validation
I am able to limit date entry to only current month and greater but I need to allow an entry of last month date upto seven days of the current month. Ultimately I want to limit the date entry into a cell to only allow a past months date seven days after the current month. I would like to use Validation for this.
-
Integrating with SharePoint
I would like some suggestions for integration with SharePoint. What are the best practices and ways to share information. Will information shared be actively updated or is it best to generate reports to be shared as static images that update at certain intervals? All suggestions would be much appreciated.
-
ERP System
Can someone please advise if Smartsheet links with an ERP system? Is there one software that is more recommended with others? I did see that there are some integrations with ERP ( Acumatica, Meisterplan, etc). Are there others that I may be missing? Please advise thank you!
