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 Prompt
Hello, 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 "Task" and Column B would be "Start Date". I'd like Column C to be "Action Date." There's…
Using smartsheet to survey clients (net promoter score)
i'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 survey monkey? Thanks
locking a formula
i 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 6. Row 7 is blank and if a passenger is not going to be on the minibus i drag them down…
Time Formula
Hi 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 next hour, in this case again it would be 3). Thanks, Melissa K
Auto-populate a value based on dropdown
I 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 thinking conditional formatting would work but it only formats text/background. Is this…
How to manage smartsheet?
Can 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 Page
Can 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 through
Hi, 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 Formula
Hello, 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”, and “% Complete” is less than 100% * Red (Task has not Started on Schedule): Today’s…
Max no. of submissions for free account
Hello, 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!
