-
COUNTIFS with DISTINCT/COLLECT
Hello all, I've been searching for an hour and I can't seem to find the proper solution. Here's an example : I need to count the number of DISTINCT Clients if Rep is John and Renewed and Refused are both unchecked. There are several rows for the same client as there are different type but here, we want to count the number…
-
Text String Question
Hello All, Quick question I just need this 4-6 digit number before - Retailer in this column but cannot get my formula to work since what I am pulling ranges from 4-6 digits. For example In my new column trying to create, I would just need 59552 from59552 -Martin Tractor or 178874 from 178874 - BROOKS TRACTOR INCORPORATED
-
Linking new entries to previous entries - tracking attendance
I'm trying to create an easier/faster way to track attendance at the multi-week classes that our health educators teach. Currently, they have to enter in static information every time they complete our outreach tool (like, address, timing etc) and I am trying to make it so that they only have to enter that information one…
-
Need formula & function for the question below
If I apply for PTO, I want to make sure it's getting subtracted from the "WR Balance Before Application" and it would be straight subtraction selecting cells & it's sorted. The main formula I am looking for is, If I apply again, my "WR Balance Before Application" should be the latest "WR Balance Left After Application"…
-
How to split the content of one cell into separate columns
I have a cell with data in this format: Approved,AAD:tammy.couch@transcoretech.com , 9/3/2019 11:06:50 AM I already have a formula for the Status Column, which is Approved. That formula is =IFERROR(LEFT([MFG Approval (archived)]@row, FIND(",", [MFG Approval (archived)]@row) - 1), ""). It works great. However, I need to…
-
Auto Add Contact with IF Formula
Hello! I am trying to get a contact to auto populate IF a column equals a certain value. For Example: So if the GC/Owner = Gallo Mechanical, LLC i want the "Submit to" = the AP contact. Can you help me to create a formula? Every version i have tried has not worked. Thank you!
-
SUMIFS with sheet reference
I've read multiple posts and articles but something just isn't work in my SUMIFS formula. I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row). Any help would be greatly appreciated.
-
Freezing Dates
I am looking to have a blank cell populate a date in a column using an if statement to check for specific values in another column. With excel I would normally use a circular reference to check if(and()) the cell was blank and that the values I want are in another column, and then populate a today(). With Smartsheet it…
-
Formula needed to count occurrence of a field value across multiple sheets
Scenario: Sheet A contains a field : Value Proposition. There are 8 rows in Sheet A. VP1 VP2 VP3 etc Sheet B and Sheet C have long lists of tasks, each task is assigned a Value Proposition (in field Value Proposition) In Sheet D (which is a Metrics Sheet) I need a formula to count the number of times that a Value…
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…