Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Smart Sheet Reminders ....
Can you set smart sheet reminders to remind you at specific times ? - Sometimes i talking with a customer mid morning and i need a reminder to go off later in that afternoon
IF/AND Formula
Hi, I am following identical logic to another formula in my sheet that is working, so I cannot for the life of me figure out why this is not: =IF(AND(Eval Payment Status]1 = "Appointment Pending (pay plan)", [Initial Pay Plan Amount Due]1 = 0), 1, 0) Here, I am trying to establish that IF Eval Payment Status shows…
Problem: Notify "Assigned To" user when a Web Form has been submitted
I have created a very simple action item tracker. One requirement was I wanted to have an automated email be sent to a specfic team member when that member was assigned via the "Assigned To" field. ( Otherwise how do people know they have assignments? ) Next requirement was to use a Web Form to make it super simple to…
In the Android app, how can I quickly jump to the last row?
I have a sheet that I am constantly adding to and it is almost 600 rows long. Is there any way to quickly get to the last row to add new entries? I am using the Android app. Thanks, Pete
Count Past Due and Coming Due Items
I would like to count past due and coming due items. For Past Due, I have a variance column that I have been able to use =COUNTIF(Variance2:Variance31, >0). The issue I have is that it is also counting completed tasks that had a variance but have since been checked off as done. Is there a way to haev it not include those?…
Live Data Connector
I have a Smartsheet linked to Excel (using the Live Data Connector). When I refresh the data in Excel all data refreshes. Is there any way to limit what appears after refreshing? I only want to show what is new and/or what has been changed in Smartsheet?
Is there a way to lock a column in a report?
Is there a way to lock a column in a report? My situation is that I have a Master sheet and then have a report where a user can enter data in one column but I don't want them to be able to change data in another column. If columns are locked on the Master then they have to be unlocked any time it needs updated by his team.…
Harvey Ball Average in a row
Hi All, is it possible to add a row of harvey balls and then get the average? If so could you share the formulas. thanks in advnce
Jira smartsheet workflow optimizations
Hello, I have some suggestions for adding to the workflows * - If a smartsheet column has the same name as a jira field directly select it in the dropdown; * - The posibility to add field templates to select in the workflow, this way you can add a predefined list from jira fields; This would make adding workflows a bit…
TRAINING!?
Is anyone available to give a tutoring lesson in the the DMV or Richmond, Va area? I have been struggling on my own and need a one on one. My business is theprinttent.com located in Richmond Va. Thank you for your assistance B
