Community

Hi!

Help!!

I'm working on a Sheet to help with our Kanban System.

As an employee takes a part from the Kanban Bin, we would them like to scan a QR code of the part taken via a form and the barcode reader on his smart phone, we have set up a test sheet using a lookup table of all parts (on a separate

Been playing with this for a while but can not seem to get this right.

Any help would be appreciated

=COUNTIFS({Editing List-3-2018 Range 2}, >=(DATE(2018, 7, 1), {Editing List-3-2018 Range 5}, ="Name"), Date:Date, <=(DATE(2018,6,30), [Assigned to: Editor]:[Assigned to:

I am looking for a formula that will help me achieve a percentage complete column that will reflect the number of subtasks complete divided by the number of subtasks.  For example:

Parent folder with 3 subtasks

Status of 1 subtask is complete

Percentage complete column will reflect 33 percent

I'm really struggling to get the syntax right on this.  I have a column called "% Complete" and a due date column called "Finish."  If the % Complete < 100 and the due date is today or already passed, I want to turn on a flag in the "At Risk" column.  Ideally I'd actually like to flag it if the due

i've used this in the past but now all queries come back

We have a process where associates fill out a form with an individual approval request.  However, they are receiving one email with multiple approvals.  The form was submitted at different times and was approved at different times.   We want one response per request. How do we ensure that this

I am needing to calculate total square footage, and if that total is less than 2, I need it to round up to 2. THEN multiply that # by a quantity cell

See that attached screenshot...

Upper 1 W x Upper 1 H (if total is less than 2, = 2) * 144 * QTY

Any ideas?

Is there a way to have more than one column for attachments? I know multiple attachments can go into the standard column, however, I was looking to label different columns for different attachment types.

I have searched the Community and found that this has been an issue since at least 2015.

Smartsheet does not provide ANY way to edit formulas en mas. Hopefully someone can provide a solution.

I have multiple sheets tracking time worked and expenses based on date range, project and service.

Each

I have a percentage in a cell that has been derived by subtracting one percentage from another. ie 5% - 10% = -5% and I now want to represent this answer as a R A G coloured blob symbol, where:

< -4.99% = G

-5.00% to -9.99% = A

 > -10.00% = R

Is thsi doable pls?...Thank