-
VLOOKUP Annoyance
Does anybody know if there is a way to rid of this annoying fly-out when viewing a sheet that has some references in it?
-
IPhone 7 Home Screen - Webform
How do I add a webform to the home screen of an Iphone 7? Is there such a feature?
-
Deleting Entries Made Through Forms
I entered some test entries through the "Forms" function and now want to go live with the sheet. It is not allowing me to delete the test entries. When I delete them, they come back when I refresh. Is there a way to delete entries once they have been applied to the Smartsheet sing the form function?
-
Project plan updates and forms
I am using SmartSheet for a project implementation and want to issue alerts using the Forms functionality. How can I include predecessor information for each of the tasks I want owners to update via Forms? Currently, I can provide the users with a listing of all tasks, however they may relate to a predecessor task that…
-
Reports - pdf or Excel ?
I send out weekly reports of our products to our customers with their expected delivery dates (which can change frequently). If an email address needs to change I am unable to see the original format of their report, so have to guess their preferred format - pdf or Excel. Short of sending copies of each report to myself…
-
Automated Alerts & Actions
OH MY! You all are so close... I've been waiting on the day that I could save my alerts and notifications to a template for over a year now. On average, I create about 10 new sheets every week, and each sheet consists of 2 REMINDERS and 8 NOTIFICATIONS. We use these sheets to track new parts to be manufactured, and once we…
-
Tracking latest Changes for Helper Column
Hey all I need some help with tracking the latest changes in a row for my sheet. My sheet is going to have repeating update requests to track each shifts production levels every couple hours. The team leaders will update the row with the current production number at every interval. I want to have a helper column that will…
-
Populate Start/End Date based on Status change
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Struggling with If statement
I am trying to create a formula to check a box in one column if a date in another column is greater than a specific date. Here is what I have, that is not working: =IF(ISDATE([Estimated Close Date]1), IF(AND([Estimated Close Date]1 = >DATE(2018, 6, 1), 1))) Estimated Close Date is a date column. The formula I am trying to…