-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
-
Counting Characters for Twitter
Hello! I'm using a sheet to track my social media (Twitter only at this point) posts prior to adding them to Hootsuite. I'm trying to figure out a way to have a column that will incidate wheather or not a text column has too many characters (140) or not. Is this possible?? Thanks, Claire
-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
time based reports?
I'm sure what I'm looking to do is not that difficult, I just can't find a way to achieve it. What I have is a sheet that consists of quote amounts ($) that are relative to a quote date. What I want to do is to look at how many dollars we have quoted that are on quotes a month old, 2 months old, etc. Ideally this would be…
-
Pairing with Epicor
Good morning, Other than downloading a Smartsheet into Excel and then uploading to Epicor, is there a way to directly integrate the 2 systems. Thank you, Lisa
-
Alert based on Report, not Sheet?
Is there a way to set up an alert based on changes to a report instead of a sheet? I have a "master" sheet that constantly grows on a daily basis and several reports for different departments to display the information that is relevent to only their department. If I set up an alert for the sheet then the department leads…
-
Add Years to a Date
If Term_Effective_Date = 12/07/15 and Terms_In_Year = 3 Years. What is the formula to calcuate the New Date? I need to add 3 years to 12/07/15. =DATE(YEAR(Term_Effecitve_Date2) + [Terms_In _Year]2, MONTH(Term_Effecitve_Date2), DAY(Term_Effecitve_Date2)) I am getting #NUMBER EXPECTED as an error. Thank you for helping!
-
Help with Duration by assigned to formula
I need to sum the duration colums by assigned to if the status is complete. I am having so many errors when trying to do this. Can anyone help?
-
Creating a customer Work Order form.
Good day! We are looking to change our current system of work orders (creating it manually on a hard copy) to doing it via Smartsheet. There doesn't appear to be a template already in existence. Has anyone ever created one? One of our primary concerns is how do we get a customer to authorize the work? Thanks Rob
-
Repeating rows based on one cell value
I am try to go from a proposal to a detail sheet for our business. We make doors and you can have from 1 to about 100 or more of one type of door. On the proposal it is only shown as one line with a quantity cell. Now what I want to do it link that to a detail sheet, the sheet that will go to production, and list those…