-
INDEX/COLLECT criteria not pulling correct unique ID
Hi There, I'm at my wits end and have spent way too many hours on this already. I am trying to pull in a unique ID from another sheet using a matching date, zip code and county. Here is the formula and a screenshot example of results: =INDEX(COLLECT({2022 ID}, {2022 Event Date}, [Event Date]@row, {2022 Zip Code}, [Zip…
-
Symbols Based on Value
I am creating a P&L Sheet to evaluate Job Profitability. I want to have two columns where symbols (Red, Green, Yellow, Blue) will show the Job Health. The first column will show symbols based on the Labor Profit Health, and the Second will be based on the Total Project Health. I would like the colors to meet the following…
-
Count from another sheet
Hi, I have 2x sheets OTIF-Sept and Report I am trying to Count the total KER -111111 orders and is incremented by 1 every new order. The count would count all orders in the Sept sheet so on a spare line if I use the following formula =COUNT([Order Number]:[Order Number]) I get the value I require. But if I run the below on…
-
Sum If Column is not blank
Hello everybody, Hope you are well! I was wondering, is there a way to SUMIF when a column at a row isn't blank? For some reason, I can't come up with a formula that will sum up the volume if the countries column below is not blank. I was able to parent them and then use the below formula, which works…
-
Formula help
Need to get a specific average from one column to another Start with Association Name column with specific name (value for Marina Isles and Pelican Sound separately) Tied to Issue Category for a specific issue Then average it out against and manually entered number. For example Marina Isles has had 3 driveways issues that…
-
Better way to write this nested if statiement?
I need to replicate this formula a few different times, and I am wondering if there is a better way? =IF([Team-MRR]@row >= [Team-125%]@row, "Top commission reached", IF([Team-MRR]@row >= [Team-110%]@row, [Team-125%]@row - [Team-MRR]@row, IF([Team-MRR]@row >= [Team-75%]@row, [Team-110%]@row - [Team-MRR]@row,…
-
Auto Reminders
Hello, We are setting up a workflow in smartsheet that once submitted via form, will flow from one approver to the next. There is no standard as for when the entries will be submitted. I need to set up a reminder for each approver so after 48 hours, if they have not approved, they receive a reminder that an action is…
-
How to SUMIF using two sheets?
Hello, I'm having a hard time totaling up numbers in a column in one of my sheets. I only want to add numbers in column "In" that is associated a particular cell ID, in this case, cell ID "49000P" out. Any help is greatly appreciated. What's the formula?
-
Is there away to take the values in a Join/Collect cell and separating it in to different columns.
I have a join/distinct/collect Char(10), and some of the Cells pull data 1, and 2. Is the formula to separate that data into separate columns? So 1 would go to the 1st column, and 2 would go into the second column.
-
Copy contents of text cell to a date cell same sheet
Good Day, I am creating a new row with Power Automate. As I understand it, I can only populate text columns with Power Automate? The one column I need to update is a Date Column. I created a 2nd text column which I populate with the date info from Power Automate. How can I update the original Date column with the 2nd…