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 October 2017
Discussion List
-
30-Day PromptIn Archived 2017 PostsHello, I'm needing to create a sheet where a task has a start date of say, 11/1/2017, and then I need to be reminded of something 30 days from the start date, 11/31/2017. Can someone help with the formula for that? (Column A would be &q…
-
Using smartsheet to survey clients (net promoter score)In Archived 2017 Postsi'm looking at whether to use survey monkey or smartsheet for a client survey. I'd like to be doing regular surveys so am thinking smartsheet. Has anyone used it for this purpose? What should I know before I start? Is it better than surv…
-
locking a formulaIn Archived 2017 Postsi have to organise a list of passengers on a mini-bus. Row 6 contains a list of those passengers, with the first column after the primary column containing a count function telling me what the total number of passengers there are in row…
-
Time FormulaIn Archived 2017 PostsHi there, I need a formula that will round UP time, for example if I have 2.5 hours worked I would need the column to round up to 3 hours. I have an hours worked column - 2.5, and a column of time paid (which needs to round up to the ne…
-
Auto-populate a value based on dropdownIn Archived 2017 PostsI am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thin…
-
How to manage smartsheet?In Archived 2017 PostsCan somebody help me how to manage the Smartsheet because this is my fist time using it, so now it's like i cant do anything on it actually i don't know anything here......can somebody help me please.
-
Form Results PageIn Archived 2017 PostsCan you view all form results in the same format as the form? In other words, seeing the form with answers provided (scrolling down through questions) rather than results being displayed across like a spreadsheet?
-
Outlook Integration - Contact List not pulling throughIn Archived 2017 PostsHi, when using the Smartsheet Outlook add-in, one of the entries is a contact list selection, whoever no contacts that I saved in the original sheet are pulling through in Outllook. Any idea why? Thanks, OJ
-
Status RYGG Automated FormulaIn Archived 2017 PostsHello, I am trying to create a status column which updates automatically based on the following criteria: * Green (Task is Complete): “% Complete” column = 100% * Yellow (Task is In Progress): Today’s Date is less than “Planned End Date”…
-
Max no. of submissions for free accountIn Archived 2017 PostsHello, is there a maximum number of submissions you can collect from a form if you have a free account or is there a max no. of times you can send out one particular form?? Thanks!