-
Embedding Smartsheet Data
When embedding any Smartsheet Data, whether sheets, reports, or dashboards, I would would like the embedded window to be completely static but still receive live updates. For dashboards specifically, I understand that the widgets have to be set to "do nothing." However, the standard Smartsheet links for "Help" and "Report…
-
ical sync update
Hi, I am trying to sync outlook calendar using ical feature. However, the updates that I am making in smartsheet calendar is not exported correctly. There seems to be bit of delay as ical is exporting old data from my smartsheet calendar. Can you please investigate?
-
what is the best way to get rid of #DIVIDE BY ZERO ?
what is the best way to get rid of the results of #DIVIDE BY ZERO. I have tried conditional formating, but that doesnt work. I am not having any insight with the if formulas. Thank you, Jef
-
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…
