-
Features that Smartsheet Should Add
I am sure that most of you have a list of things that you would like from Smartsheet. I have a short list to get us started. Lets add to this and see if they can make it happen! 1 - Ability to paste more than 50 rows at a time. * 2 - Extend the 5,000 row per sheet limit. * 3 - Ability to create a new sheet based off of a…
-
formulas disappearing
I'm having an issue with the formula I created to automatically check a box disappearing if I happen to manually check that box. I have it set up so when a certain box is check marked this will cause another box to then be check marked. I'm wondering if there is a way to override the formula immediately disappearing when…
-
Double Entry from Webform
Hi, I am having an issue where we are using QR codes to access the webform on a mobile device and the data being sent through 2-3 times. There is double data and it is causing us to have to comb data and delete unnecessary entries. Is anyone else experiencing this and is there a way to make this stop happening? Thanks, Lex
-
Working Days without Enabling Dependencies
Is there a way to plug in the Working Days criteria (non-working days, holidays, etc) without turning on Dependencies? I'm trying to build a sheet that recognizes weekends and company holidays as non-working days, but I don't need Predecessors or Duration columns. In the past I've enabled Dependencies then literally…
-
RYGB Balls
I created a nested function to color designate the status of my projects tasks: =IF(Status="Not Started","Red", =IF(Status="In Progress","Yellow",=IF(Status="Complete", "Green",=IF(Status="N/A","Blue)))) The Red, Yellow, and Green balls work perfectly, however, when I select N/A from the drop down in the cell I get…
-
formula help
I am attempting to get a formula to count a range if the column next to it has the correct category. for example DF 1.1 DV 2.1 DF 3.3 DF 1.2 DV 2.1 I want to count how many numbers lay between 1 and 2 in the category DF, and am struggling to get the program to do this. Any help would be appreciated.
-
Auto populate cell information
I have built a sheet for tracking production downtime in our facility. I am looking to be able to streamline the amount of time it takes someone to entry sku specific information. So say the item has the following traits (Sku Number: 1035) (Flavour: Orange) (UPC code: 1234567890) & (Brand: Smiths) I would like to be able…
-
Implementation of web forms Idea
I have been working on a somewhat complicated 5S audit for a while and I thought I would share one of my favorite ideas we have had. We needed to create an audit sheet that was filterable by plant, then area, then by zone, and could have any amount of submissions per each zone, and included pictures and notes. We didn't…
-
% Completed and Task Finished
I would like to have the % completed set automatically to 100% when the Task Finished is checked. Any suggestion on how to do that? First smartsheet struggles...
-
Forms
Hi - I am trying to write a form and would like to do the following: 1. Are you a member of XYZ? If so, what is your membership number? Is there an easy way to do it or do I have to have a separate column in the sheet and therefore another section on the form? Thanks
