-
Columns Automatically Unhiding With Form Submission?
Hello all, We use a form for our open order sheet. We removed an item from our product list and I want to hide this item in our open order sheet (not deleted it, incase we add a new product because I already have all the automation and reporting set to include these columns). I have NUMEROUS hidden columns in this sheet,…
-
E-mail notifications
Hi, I have a 'Sheet' named 'Main sheet' with forms submissions arriving all the time, within the 'Main sheet' there is a field called 'Employee Department', when populated from the form this looks up the 'Project Sponsor' from a further 'Sheet' named 'Lookup' and pulls the e-mail through to the 'Main sheet' - this all…
-
Allocating the % of the time can be worked during the day
I am trying to allocate the time that the employee can use for that task during the day to smartsheet. How can I for example if employee has 8 hours of work to do on one task, but he can only spend 50% of his day to this task. This means it will take him 2 days instead of 1 day since he can only work for 4 hours a day. How…
-
Blank Rows in Gantt - Automatically get populated by start date
In Gantt format - I leave some rows blank to separate workstreams or buckets of work. But for whatever reason - Smartsheet goes and fills just the start date automatically in these row. I delete them, and then after I save, they come back again. They are harmless, but misleading and hurt the aesthetics of the chart. How…
-
Variations of Forms Recently
Hello, We use the form function for all of our production orders everyday and recently, the form has been flip flopping between two different layouts. One is where there is the capability to upload multiple documents at a time and one where you cannot. Is Smartsheet doing some sort of testing or updates? Appreciate any…
-
COUNTIFS problems
I am doing a metrics sheet to give department heads better visibility on our workflow. One of the metrics I need is how many items have been shipped, but not yet invoiced, I have a date shipped culumn (date) and an invoiced check box (boolean). Several other formulas have similar setup criteria and are also not working.…
-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
Recommended Tablet?
We have several departments are regularly using Smartsheet tablets. The tablets we currently have deployed are reaching end of line. Can anyone recommend some tablets that work well with Smartsheets? We are currently using older Lenova Yoga tablets which are android based; however, we were considering possibly replacing…
-
Receivable Over View
Dear all, Our current receivable has many terms such as advance payments / 30-45-60-120 days deferred. We are maintaining it in an excel sheet but I am afraid some receivable might be missed. What I am looking for is a sheet where I enter the customer invoice value and by when what percentage of that value will I receive.…
-
High Contrast and low vision
Hey smartsheeters! I use smartsheet(s) everyday and I have a rare retina disease that makes the bright white screens hard to read, is there a way to invert the screen colors? A nice bland gray with black or white letters would be lovely. Most of the programs I use invert based on my PC settings, but not smartsheet. Let me…