-
How to collect multiple Successor values?
Here's a link to my initial post which helped get me this far. RECAP: I use a combination of a Successor formula & Join/Collect in an attempt to report for my team the next tasks and assignee(s) in our waterfall workflow. I am able to successfully return the next assignee only when there is a single successor. I need to…
-
Help me brainstorm with my staffing calculation Issue.
Hi all, So, help me out here i'll state the facts and the current case here. I need a staffing calculation every hour per zone. Data is received every 15 minutes through a shuttle. Below you can see the current process. Don't mind the red square and mark. Data is being updated in box and moved to smartsheet with a data…
-
SUMIFS with date and category referencing another sheet
Hi - I have a cashflow chart that I want to pull expenses into by category and month. The expenses are located on another sheet with a dropdown list that is the same on the cashflow chart. I have tried this formula but it is not returning the results - just $0.00 =SUMIFS({Expenses Amount}, {Expenses Category},…
-
Help with addition to formula
Hi, i need to make an addition to the below formula please. I need to add if column type is issue and impact score is 4 - gray, 3 - red, 2, amber and 1 green =IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >= 20), "Gray", IF(AND(Type@row = "Risk", ([Impact Score]@row * [Likelihood Score]@row ) >=…
-
How to Have Children Rows Updated based on Data from Parent Row
I am setting up a sheet which will have many parent rows with many children connected to them. There is a column called "Escalated to AM?" which is a drop-down with the option to select "Escalated". There is another column called "Escalated?", which is a checkbox column. I want to add a formula to the "Escalated?" checkbox…
-
Counting with multiple criteria
I dont know what im doing wrong here, im trying to count anything with Mentoring and if Q1 is found =COUNTIFS({RelatedGoalWoW}, HAS(@cell , "Mentoring")) + COUNTIFS({Quarter}, HAS(@cell , "Q1"))
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
INVALID OPERATION ERROR - HELP NEEDED
Thank you in advance for your help. I actually worked with Smaartsheet's AI Help to generate and work through the formula. I have checked it twice and still get the same error message. Here is the formula: =IF(AND([Tester ID]@row = {DE2ET Tester ID}, [Scenario ID]@row = {DE2ET Scenario ID},…
-
How can I use Conditional Formatting for date in the past or future when a formula created the date
Hi Everyone, Thank you for your time in reading this. How can I use Conditional Formatting for date in the past or future when a formula created the date? The black columns are different dates generated. The 2 yellow columns are then selecting the relevant date based on different criteria. The white columns are me trying…
-
Users Submitting From Excel to Existing Sheet
Goal: I'm looking for a way for employees to copy/paste or upload new rows of data from Excel into Smartsheet without seeing the full sheet and ideally without needing a Smartsheet account. Project Overview: I'm building an expense report system where employees submit weekly expenses for review and approval. Currently,…