-
Problem with nested IF/CONTAINS for Multi-Select Column and Zeros
Hi all, How do I get rid of the zeros in this formula? (And why does it seem to work fine for Monday and Tuesday only selections?!!?) Below is the text of the formula and it is citing a multi-select column. Class Days Short is a text/number column. =IF(CONTAINS("Monday", [Class Days]@row), "M, ") + IF(CONTAINS("Tuesday",…
-
Assistance Needed - Formula - #INVALID OPERATION
Hello SS Gods, Assistance is needed. So I have 3 columns, Ready to Pair, Not Ready to Pair Date and Not Ready to pair + 2 weeks. The Ready to Pair? field is a drop down list. Once the status "Ready to Pair in 2 Weeks" is selected, I have a workflow set up to record the date in the Not Ready to Pair Date field. I am using…
-
repetitive work
Hello - I manage a small team that does work that occurs on a 30-day timeline with certain milestones within that timeline. I want to create a tracker, but I don't want to add the steps each time. I would like to obtain updates twice a week, but only for the next one or two steps in the process. Does someone have a good…
-
Can we use a Sum or Avg formula to rows/columns which has a IF condition.
I was trying to prepare a report in which I used a IF conditions to get the expected value based on my clients response from the forms. Now, I want to do a SUM or AVG with the rows that I have the conditions. I get #DIVIDE BY ZERO ERROR when AVG is applied & I get the final value as 0 when I apply the Sum formula.
-
Generate sequential numbers base on task column
Hello everyone, Hope you are doing well! How can I generate sequential numbers base on task column that has parent and child tasks, where each parent task has three child tasks, and each child task has one sub task. Please find below screenshot for better understanding & for now I have filled this sequence manually, I want…
-
Summing $ from Multi-select dropdown that includes text
I am running into a problem that I have not been able to find in the community. I have a multi-select dropdown column that includes text and $ values, e.g. A - $25.00, B - $30.00, etc... I would like to take the selection from the column and sum the $ values. I would then multiply that by the Qty, =( )* Qty@row. I am able…
-
Snapshot Trending
Looking for your help, we have a project health column (red, amber, green) on our register that we are looking to trend week on week. Or to run a report on whats changed yellow to red or green to yellow for example. And no idea how to do that . I looked at automation and the trigger on has 'changes to' it doesnt allow…
-
Nested Formula IF(NOT(CONTAINS AND IFERROR(SUM(CHILDREN
Hi There! I'm hoping I'll eventually have time to take the formulas training that smartsheet offers but in the meantime, can anyone help me write a formula that's above my pay grade? 😁 I have a formula for calculating our overall progress for a project. However, I've had to break the project down into tasks that, while…
-
Looking for a formula, to add the total of an invoice column, with a criteria from another column
I have 2 columns, one the Invoice Amount & Location. I want to be able to calculate the total of the Invoice Amount Column, with a criteria in the Location Column Hope that makes sense Many thanks
-
Need a formula for % completed to change status health, as well as % completed to update status
Hi there, I am after two formulas: FORMULA ONE I need my % Complete to reflect the Status, example below: 0% equals status - Not Started 1 - 99% equals status - In Progress 100% equals status - Complete FORMULA TWO I need my Health status to reflect the following: Completed equals Green In Progress equals Yellow Not…
