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 March 2017
Discussion List
Web forms
Hi, i want to create a more complex web forms. did you have integration with any other web form app?
New conditional notifications request
I like the new conditional notifications. I especially like keying on deleted rows and being able to disable them. Nice touches. It appears the 6 types of Notifcations are separate entities and that one instance can not be changed or cloned to another. Is this correct or did I miss something? If I am correct, then I will…
Parent Sum Children Duration
Is there a way to sum the duration of children rows? Parent row - 20 days duration Child - 5 days duration Child - 10 days duration Child - 15 days duration
Imported sheet formulas not all working
I imported my sales tracking sheet and most of the formulas are working but some of them are not. this is what they say: #UNPARSEABLE#BLOCKED#BLOCKED Here is a screenshot of what I have in some cells. https://screencast.com/t/J1Rvx4iz0 I don't know how to fix this.
Visualise Planned v Actual Effort
Hi. I was originally using RAG balls to denote if a development task would be delivered on or within the estimated time (display green ball) or if late (display red ball). * We use Initial estimate column to estimate the dev in days * We use an Actual Hours logged column (cumulative) for the developer to log their Actual…
Change smartsheet hotkeys
I have a portable keyboard that doesn't have the insert key. Is there a way i can reprogram or change the create new row hotkey?
Constructing User-proof formula
Any ideas on constructing more user-proof formulae? I'm having trouble with users inserting rows in a sheet versus appending new rows at the bottom. Locking rows doesn't prevent an insert (would be nice if a non-admin user couldn't insert when adjacent rows are locked). I've used the following formula to ensure the first…
Report limits
Is there a limit to the number of sheets that I can have a report pull data from?
Web Forms and entering data via android smartsheet app
I have built my sheet and built the web form. I have downloaded the smartsheet app onto my android tablet. I sen the email link and accepted as the user that i want to have access to the web form. How do I now see and use the web form when in the smartsheet app? It doesnt appear as an option in my list of available items…
Formula IF Due date help!
Hi, I'm trying to do the below: - When a date range - TODAY () is less than 30 it shows 'Current,' - When a date range - TODAY () is less than 60 it shows '30' - When a date range - TODAY () is less than 90 it shows '60' - When a date range - TODAY () is less than 90 it shows '90' I can get it to say current, and it works…