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.
Archived 2017 Posts
Archives for December 2017
Discussion List
Best way to calculate stats on a sheet tracking form submissions
I have a SmartSheet that logs "installation issues" as they are submitted via web form. The sheet tracks the "locations" id number, address, owner, manager, issue, issue type, and who is working on the issue. Its a tracker you could say. I want to be able to calculate how many of "issue type" A or B have been submitted via…
Alerts & Actions
Hi Everyone, I am looking to see if you can set up an alert that will trigger and email say if the dollar value is over 1500. Has anyone run across this? Thanks. J
Creating IF AND THEN statement
Hello I need help with creating if and then statement to perform the following. If Recruited From = Referral And Store Start / Transfer Date = Date Then Store Start / Transfer Date +90 days Here's the code I have and it's giving unparsable. =IF (AND([Recruited From]147 = "Referral", [Store Start / Transfer Date]147= DATE,…
Adding numbers that fall in a date range
Just learning Smartsheet. I need assistance creating a formula that will create a sum based on calendar months. I have two columns: one for a number of appointments, the second is a date column. As an example, I would like to have Smartsheet calculate appointments that fell in December. Thanks for any assistance.
Auto Cell Linking With Templates
I need a way to auto link a row from new sheets with a master sheet because I am constantly using a template to create new project sheets containing the same info categories on each one but it takes up to much space to have all the projects on one sheet so i opted for individual project sheets. I need to be able to add key…
Form Submission Organization in Sheet
Is there a way to automatically move a new form submission to a nest under a particular row? For instance, I have 4 parent rows that nest several rows underneath and would like any form submissions to automatically be assigned under one of those 4 parent rows based on information that's submitted (if this, then nest under…
You do not have permission to edit forms on this Smartsheet
I am the Owner of a Smartsheet, ID #4329033635784580, and have already created 22 forms for it. I cloned the last one I created and edited it. When I tried to save it, I received the error, "You do not have permission to edit forms on this Smartsheet." Why can't I save this form on the Smartsheet? Is there a limit to the…
Functionality Request - Egnyte
It would be incredibly helpful to have full integration and send documents into Egynte's document depository from Smartsheet.
Update Shared Users of functionality changes within a sheet
Does anybody know of a way to update all shared users (to a particular sheet) on new sheet functionality? It seems the only way to do this is set up a separate email where I have to pull out all the user names and send via an email client i.e. outlook. An option within Smartsheet would be much easier. For clarity, this is…
COUNT where cells <>"N/A"
Hi, I'm struggling to combine a SUM and a COUNT together (keeps returning an error). =SUM([CELL 1]22:[CELL 4]22) / COUNTIF([CELL 1]22:[CELL 4]22, <>"N/A") This returns a #DIVIDE BY ZERO. CELL 1 to CELL 4 could contain the numbers 1 to 5 or N/A. The end result is to provide a percentage out of 100% for the total cells with…